x

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

more ▼

asked Apr 07, 2010 at 03:53 AM in Default

Naina gravatar image

Naina
63 13 13 14

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Apr 07, 2010 at 04:12 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

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, 2010 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, 2010 at 07:27 AM Matt Whitfield ♦♦
Thanks a lot Matt
Apr 07, 2010 at 07:47 AM Naina
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Apr 07, 2010 at 05:22 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.7k 75 79 108

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, 2010 at 06:27 AM Naina
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1842
x729
x61

asked: Apr 07, 2010 at 03:53 AM

Seen: 2174 times

Last Updated: Apr 07, 2010 at 05:50 AM