|
|
Posted by Erland Sommarskog on 09/29/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
Navigation:
[Reply to this message]
|