Posted by Erland Sommarskog on 07/19/07 15:41

Erwin Moller (since_humans_read_this_I_am_spammed_too_much@spamyourself.com)
writes:
> Now I need to do some upgrading on the application and I would like to
> have a copy of the database from MSSQL2000/8 to MSSQL7.
> Is that also possible?

You would have to build the database on SQL 7 from scripts, and move the
data with bulk load. I don't know you did the import in the other direction,
but going to a higher version it's possible by backup/restore or simply
attaching the database to the higher version. Going to a lower version
this is not possibe.

> Or should I download Microsoft SQL Server Express and use that instead
> of my MSSQL7? Is it better?

Well, SQL 7 came out in 1998, SQL Express in 2005, so there are some
more features. But there are also some things that don't really work
as in SQL 7. For instance the old-style join *= is available only
in compatibility level 80 and lower.

Nevertheless, I would recommend going to SQL 2005 if possible.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]