Posted by Hugo Kornelis on 01/26/06 22:37

On Thu, 26 Jan 2006 05:02:36 GMT, Neil wrote:

>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

Hi Neil,

If you're upgrading anyway (whether from SQL 7 or fram Access 97, I
don't know), then I'd recommend you to go for SQL 2005. Every upgrade
you ever do will require you to deal with SOME incompatibilities. But
from SQL 7 to SQL 2005 should be relatively easy. (From Access [any
version] to SQL Server [any version] might be more trouble).

The payoff will be bigger if you go straight for 2005 - especially when
you start using the new features. Plus you'll be settled for some time
to come!

--
Hugo Kornelis, SQL Server MVP

[Back to original message]