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: 333
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