Posted by Neil on 01/26/06 07:02

Hi, Erland. Thanks for your reply. Given the incompatibilities between SQL
2005 and SQL 97, do you think it would be wise to just upgrade to SQL 2000?
Also, any ideas about which one might be better suited for Windows 2003
and/or an ODBC environment (using Access MDB as a front end)? Thanks!

Neil


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns972AE1D20309BYazorman@127.0.0.1...
> 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]