Transfer database from SQL Server 2012 to SQL Server 2008 [closed] Transfer database from SQL Server 2012 to SQL Server 2008 [closed] sql-server sql-server

Transfer database from SQL Server 2012 to SQL Server 2008 [closed]


You must export the database as text (.sql) and the import it back. See Run the SQL Server Import and Export Wizard. There are also 3rd party tools, like SQL Compare and SQL Data Compare.


Steps to migrate:

1) get the list of tables in which entry was made before in SQL Server 2012

2) Generate the scripts in SQL Server 2012 and in advance option select "data only" for export type

3) using python run the SQL statements with reference to list of step 1 insert values in SQL Server 2008