• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

move db from sql 2012 to 2008r2

Hello,
I need to move a database that is currently on sql 2012 to 2008r2. Has anyone done this? If so, what steps did you follow? Did you just script it out?
Thank you in advance!
0
carjar1217
Asked:
carjar1217
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
you cannot go backward, the best way is to export the data or generate the schema and data scripts on sql 20112 and run them against a database in 2008
0
 
nemws1Database AdministratorCommented:
Right click the database, go to "Tasks" and try either the Import/Export tools or even better yet the "Database Copy" task (although this requires SSIS).
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now