Restoring SQL 2012 to SQL 2008 R2

I have generated teh script file and now i need to put that into SQL 2008 R2.  IS there something special that needs to be done to that script file or do i just open it in 2008?  Any help is appreciated.  Thanks!

Perry
swilliamson-mwnsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott PletcherConnect With a Mentor Senior DBACommented:
You might be able to use the "Database Copy Wizard", running it from the SQL 2012 instance, and using the SMO method (i.e., not detach and attach).  You'll need to set all the "Scripting" options first.  It's not easy, but you might be able to get most (or even all) of the objects copied over that way.
0
 
Lee SavidgeCommented:
Are you trying to restore a database backup from 2012 to 2008? If so you can't. You can't restore a backup to an earlier version of SQL.
0
 
swilliamson-mwnsAuthor Commented:
I am tryin g to move a DB from a 2012 SQL server to 2008 R2.  I thought i could generate a script from the 2012 and then pull it into 2008.  Is that not correct?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Deepak ChauhanSQL Server DBACommented:
what this script does?
0
 
swilliamson-mwnsAuthor Commented:
No Clue.  im not a database guy.  I have a DB that is on a 2012 server and needs to go on a 2008R2 SQL box.  looking  for how to get that done.
0
 
Lee SavidgeCommented:
It is not easy. Scripting the table structure out is one thing but you need to deal with the data move, indexes, stored procedures, functions, views, etc.

http://solutioncenter.apexsql.com/restore-sql-server-database-backup-to-older-version-of-sql-server/

I've done it once and I don't want to do it again.
0
 
Deepak ChauhanSQL Server DBACommented:
Yes that’s correct! Some new features come in picture in SQL Server 2012 like (Sequence, column store index, pagination.. and so on). So you need to correct and modify the code and make it compatible with SQL 2k8.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.