how to copy sql server 2012 to sql 2008r2

Carlos kambui

11y931

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
http://superuser.com/questions/468578/move-database-from-sql-server-2012-to-2008
Rajeesh Menoth11y ago
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 kambui11y ago
thnx i just decided to drop and create all the tables
Khrizz11y ago
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 kambui11y ago
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 Choudhary11y ago
Hello @carlos can you explain what is mean by copy of sql sever . are you asking about backup of database........