August 21, 2012 at 9:15 am
Just to confirm my thoughts here... To restore a DB on SQL 2008 R2 to a SQL 2008 server, I need to right click the DB > Generate Scripts and just select everything, right, and then run this on the other server?
August 21, 2012 at 9:19 am
Don't script data. Not unless your DB's a few MB. Any more than that will kill SSMS.
Script the objects, use bcp or SSIS for the data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 21, 2012 at 10:50 am
Gail is correct and has the best solutions. You need to script things out and recreate them on the 2008 instance. SQL Server 2008 R2 is a different version.
You can also use third party tools, like SQL Compare/Data Compare.
Disclosure: I work for Red Gate.
August 21, 2012 at 11:13 am
So each individual piece has to be scripted out...?
Also, what about SSAS databases?
August 21, 2012 at 11:19 am
No, script all the objects in one go, you can do that with the script tool that you mentioned. Then either bcp the data out or create an SSIS package to transfer the data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply