Converting from SQL Server 2000 to 2005 for ASP.NET web App
- by Bazza Formez
Hi there,
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 file 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