HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How do I load just the data from SQL Server 2005 backup into a 2008 R2 database?

Submitted by: @import:stackexchange-dba··
0
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.