Please let me know is there any tool available to check the SQL Server 2000 to Sql Server 2008 Migration, so that we can anlyze the procedure or any discrepancies with the Database we are trying to migrate and list all potential issues.
Answer by Fatherjack ·
I've used the tool Matt mentions (or previous versions) to get from 7 to 2000, 2000 to 2005 and now 2005 to 2008. As Matt says, it doesnt pick up on everything but the deprecated bits are highlighted along with other things you could easily miss. Use the tool and test the upgrade in your dev environment a couple of times before going live and you should be fine.
Answer by Matt Whitfield ·
A good first start is SQL Server 2008 Upgrade Advisor. However, don't let the tool be a substitute for proper & thorough testing after migration - because there are lots of little issues in the way the systems can be used that can cause issues.
Having said that, it's pretty likely that you won't run into any major issues, if you haven't been using any deprecated methods (i.e. ones that are publicly declared as having a limited future) in your DML / DDL.