CODEWITHSUNDEEP
sql-server
Alex
Alex

Reputation: 2111

Compatibility - SQL 2005 vs 2000

I recently changed my compatibility mode of my sql server 2005 form 2000 to 2005. Is there a utility that can scan my sp and functions and tell me if I have any compatibility issues?

Upvotes: 1

Views: 401

Answers (1)

u07ch
u07ch

Reputation: 13692

I am not sure if it works from inside sql 2005; but if you still have a sql 2000 server then MS have an upgrade advisor that will report on your code. If you don't scripting out all the objects and trying to run them back into a new database set as sql 2005 mode is a fairly good way to test the migration.

Depending on your application be careful just switching there are syntax differences and connection options that changed between 2000/5 beyond just stored procedure changes. If your application runs sql queries natively (not sp's) then the application may have compatibility issues beyond just the internal database code.

Upvotes: 2

Related Questions