snippetsqlMinor
How do I load just the data from SQL Server 2005 backup into a 2008 R2 database?
Viewed 0 times
thehow2008justsqlintodatabase2005loadserver
Problem
I created a 2008 native database and I have the structures in place but need to load data from a 2005 backup.
Solution
Restore the 2005 backup as a different database, then use a tool like Red-Gate SQL Compare to copy the data. Once you're happy, drop the restored copy of the 2005 data.
Context
StackExchange Database Administrators Q#5184, answer score: 2
Revisions (0)
No revisions yet.