|
Hello, 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. Thanks Naina
(comments are locked)
|
|
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. Thanks a lot ..... Please let me know Is this is only Microsoft tool available to check the SQL Server Migration as we can only use Microsoft tool. N Also is this tool is installed default with SQL SERVER 2008 Installation package??
Apr 07 '10 at 06:27 AM
Naina
This is a microsoft tool, and the link was the link to download it. I don't believe it's installed by default.
Apr 07 '10 at 07:27 AM
Matt Whitfield ♦♦
Thanks a lot Matt
Apr 07 '10 at 07:47 AM
Naina
(comments are locked)
|
|
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. Thanks a lot ..... Please let me know Is this is only Microsoft tool available to check the SQL Server Migration as we can only use Microsoft tool. N Also is this tool is installed default with SQL SERVER 2008 Installation package??
Apr 07 '10 at 06:27 AM
Naina
(comments are locked)
|
