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.