Upgrade SQL 6.5 to 2000

[CruelIO]

Hi there

We have to upgrade our old SQL 6.5 to an SQL 2000 platform.
The 3 main reasons for the upgrade is
1) Better performance
2) Better stability
3) More nestinglevels

However to do the upgrade as easy as possible its been choosen put the SQL 2000 server into 6.5 mode. But how does that affect the perfromance and the stability?

Is there any issues concerning the 6.5 mode we should be aware of?

Thanks

 

[JamesLean]

Firstly, you can't put the whole server into 6.5 mode. You can only set the compatibility level at the individual database level.

Secondly, doing this is only meant to be a temporary measure if your applications would be affected by new SQL 2000 functionality. You would not normally run the database in a lower compatibility mode for an extended period of time - just until you had updated your apps.

Having said this, there should be no performance or stability issues as such. The compatibility mode only affects certain functional and syntactical areas of the database.

--James

 

[RobertT687]

One of the syntactical areas alluded to by JamesLean is the use of single quotes instead of double quotes around literals in stored procedures and TransAct SQL. 'literal' is OK, but "literal" won't compile. Just something to look out for.