Transfer database from SQL Server 2012 to SQL Server 2008
database, database-migration, sql-server, sql-server-2008, sql-server-2012
Solution
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.
Problem
I already have a database in SQL Server 2012 Enterprise edition. It contains : - tables - views - procedures - objects Now I want to downgrade the database to SQL Server 2008 Enterprise edition. I know there is no direct option. I tried to backup on 2012 and then restore on 2008. Not working. Any Idea on how to completely transfer database ?