Home All Groups Group Topic Archive Search About

Tool for checking compatibility issues before raising

Author
23 Apr 2007 9:37 PM
Rod
We have a large, complex, old database running at 6.5 compatibility level.
We want to raise it to 8.0. It would be an extremely onerous task to
manually check for any issues. Is anyone aware of a tool that can do this?

Author
23 Apr 2007 9:59 PM
Erland Sommarskog
Rod (evans.rodnospam@gmail.com) writes:
> We have a large, complex, old database running at 6.5 compatibility level.
> We want to raise it to 8.0. It would be an extremely onerous task to
> manually check for any issues. Is anyone aware of a tool that can do this?

If there is a tool, I doubt that it would cover everything, so in the
end you would need to test a lot anyway.

And that's really the only advice I can give: test, test and test.


--
Erland Sommarskog, SQL Server MVP, esq***@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

AddThis Social Bookmark Button