Sunday, August 17, 2008

How to Migrate an Analysis Services database from SQL Server 2000 to SQL Server 2008 RTM?

You first need to add the Wizard which does this migration to the Tools menu in the Management Studio. This note shows how you can do this.

Step 1: Open Microsoft SQL Server Management Studio.

Step 2: Connect to your installed instance's Database Engine by providing the authentication information. For this note the installed instance was Windows Authentication.

Step 3: In the Mangement Studio click on

Tools|Externl Tools...
This opens the External Tools window as shown.

Click on the ellipsis button for the Command textbox.
This opens the Open File window as shown

Click on Migration Wizard and click Open
This adds the file location information into the External Tools window. Change the default title to
something different, herein MigrationWizard as shown. Click OK.

Migration wizard gets added to the Tools menu as shown.
Step 4: Click on the Migration Wizard just added in the Tools menu.
This opens the Welcome to the Analysis Services Migration wizard window.
This is the starting point for you to begin your migration.

How to remove the added entry?
It is just as easy. You can remove from the External

Happy migration!!!

No comments: Protection Status