Posted by Erland Sommarskog on 10/01/15 11:34

Neil (nospam@nospam.net) writes:
> We are running SQL 7, using Access 2000 as a front end. Our network
> person is wanting to migrate to Windows 2003 (we're currently on Windows
> 2000), and wants to know if we should migrate to SQL 2003 at the same
> time. Are there major changes between SQL 7 and SQL 2003, and how hard
> of a task would it be to migrate our single database to a new version of
> SQL?

There is no SQL 2003. There is SQL 2000 which is very mature now, and
there is SQL 2005 which was released just over a month ago.

While there are vast improvements in SQL 2005 over SQL 2000, migrating
your database to SQL 2005 can very well be a simple task, although there
are some incompatibilities, particularly if you head for compatibility
level 90 (which I recommend).


--
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]