Sql Server Coversion

Question

Hi How to convert Sql server 2012 to sql server 2008( I Cant restore the data base(2012 to 2008) Thank You

Abhay Shanker · Answer

you can't you can NEVER restore from a higher version to a lower version of SQL Server. Your only option is to script out the database and then transfer the data via SSIS BCP linked server or scripting out the data

Jignesh Trivedi · Answer

No this is not possible we can move forward... means we can restore the database from 2005 2008 to 2012 version but not in reverse order. but there is work round Please refer http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/

Munesh Sharma · Answer

go on this link http://dba.stackexchange.com/questions/20588/restore-sql-server-2012-backup-to-a-sql-server-2008-database

Karthik M · Answer

Hi Rajesh you can take sql server 2012 scripts with data and will execute in 2008