November 2, 2006 at 6:21 am
Hi there!!
This is Rahul here.
I have database on SQL2000 server.
I want to migrate my database to SQL2005.Could u help me in knowing what could be the possible compatibilty issues that are in migration of database from sql2000 to sql2005?
I am lookin' for changes i will have to make in stored proc's and other system objects that are no longer supported in sql2005 and can cause my application give error.
for example empty SET clause is no longer allowed in sql2005
November 2, 2006 at 8:14 am
you need to set up a test server, restore all your databases and check every sp, job, dts package and application you have against the new server to see what the problems are
November 2, 2006 at 9:18 pm
Isn't there any resource which can provide exhaustive list of all the features which are no longer supported in sql2005 from sql2000.
November 3, 2006 at 12:13 am
See if you can get hold of the SQL Server 2005 upgrade adviser. It's probably available for download from MS.
With the testing I'm doing for upgrades, it's not so much the list of features that have changed, but the side-effects that have caused problems.
eg the query optimiser has changed, meaning it sometimes runs queries different to 2000. I've had 2 queries that worked in 2000 and didn't work in 2005, simply because the way the query was run changed.
Most stuff that worked in 2000 still works in 2005. Some stuff is deprecated, meaning it still works, but isn't guarenteed to work in the future.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply