How do I load just the data from SQL Server 2005 backup into a 2008 R2 database?
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.