how to copy sql server 2012 to sql 2008r2

Question

how to copy sql server 2012 to sql 2008r2 in two different computers

Upendra Pratap Shahi · Answer

http://superuser.com/questions/468578/move-database-from-sql-server-2012-to-2008

Rajeesh Menoth · Answer

Hi, You don't want to drop and create any tables, generate the scehma and data in sql and execute in 2008r2.. Check this Video tutorial : http://blog.sqlauthority.com/2012/07/18/sql-server-generate-script-for-schema-and-data-sql-in-sixty-seconds-021-video/

Carlos kambui · Answer

thnx i just decided to drop and create all the tables

Khrizz · Answer

AFAIK, you cannot attach database created in a higher version to a lower sql server version . Even backup file won't work. Here's what you can do, 1. Download & install sql compare tools (SqlDelta, RedGate), create a new Db in the 2008r2 sql, then import all objects and data from 2012 to 2008r2 using the compare tool. 2. Generate scripts for the db objects in SSMS of SQL 2012 and run that scripts in the 2008R2 SSMS. Have your own copy of this version and install your own SQL 2008R2 so you won't have problem in the future. (Please take note that on both cases, there may be objects that may not be compatible in the lower version so might have to adjust the scripts.) 3. If possible, just install SQL 2012 Express on the client. Hope this helps.

Carlos kambui · Answer

i have developed a system with sql 2012 and now i want to install to client where he has sql 2008r2 i have tried to attach but is throwing an error kindly requesting for assistant

Pankaj Kumar Choudhary · Answer

Hello @carlos can you explain what is mean by copy of sql sever . are you asking about backup of database........

how to copy sql server 2012 to sql 2008r2

Answers (6)