Database upgrade from SQL Server 2012 to 2008
You cannot convert a SQL Server 2012 database file to a SQL Server 2008 database file. You cannot go down. Database file compatibility is only available from old version to newer, not vice versa. Indeed, you can convert a SQL Server 2008 database file to a SQL Server 2012 database file.
Use the integrated SQL Server tools:
- Right click on the database.
Following the wizard, at the end of it,
Advanced Scripting Options
click the "Advanced" button, select the version of SQL Server for which you want to generate scripts using the option
Script for Server Version
. Alternatively, you could generate scripts to export the schema of your objects and / or data by selecting the option
Types of data to script
, as you can see in the screenshot below:
The time it takes to create the process (schema and data) will depend on the amount of data you want to export, of course. As @Arun suggested, take a look here in more detail here using step by step instructions.
source to share