question

Naina avatar image
Naina asked

Migration Checker Tool for SQL Server 2000 to SQL Server 2008 Migration

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

sql-server-2008sqlmigration
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Matt Whitfield avatar image
Matt Whitfield answered

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.

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Naina avatar image Naina commented ·
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??
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
This is a microsoft tool, and the link was the link to download it. I don't believe it's installed by default.
0 Likes 0 ·
Naina avatar image Naina commented ·
Thanks a lot Matt
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered

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.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Naina avatar image Naina commented ·
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??
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.