Converting from SQL Server 2000 to 2005 for ASP.NET web App

I'm moving my ASP.NET website to a new provider. Only problem is, old host support my SQL Server 2000 db. New host only supports SQL Server 2005. How should I go about the conversion ? Can I simply produce a backup of the 2000 (.bak) file at the old host, and restore that fi开发者_运维百科le into SQL Server 2005 at the new host ? Or is there more to it ??

Note that I don't own a copy of SQL Server 2005 at home... and I'm trying to avoid having to do so.

Thanks, Bazza

Simple restoring of backup is enough. It workes fine for me.

Generate Deployment scripts using "Database Publishing Wizard" for your Sql200 database and select target dataabse type as "sql2005". It should work flawlessly as we have experienced the same in past.

Do you use Data Transformation Services (DTS)? This SQL Server 2000 feature can't be migrated right away into SQL Server 2005. You'll have to migrate your DTS-packages to SQL Server Integration Services.

Running the SQL Server 2005 Upgrade Advisor helps identifying this issue.