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

Posted by Bazza Formez on Stack Overflow See other posts from Stack Overflow or by Bazza Formez
Published on 2010-04-14T05:47:59Z Indexed on 2010/04/14 5:53 UTC
Read the original article Hit count: 331

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about server