How do I load just the data from SQL Server 2005 backup into a 2008 R2 database? I created a 2008 native database and I have the structures in place but need to load data from a 2005 backup.
Is your new structure different of the structure in SQL Server 2005? You may restore the backup entirely, there is no need to create first the structure and then load the data.