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

Question

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 ?

Answer 1

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.