Introduction to MSSQL Server Analysis Services: Migrating an Analysis Services 2000 Database to Analysis Services 2005 - Page 3
November 21, 2005
Verification: Examine the Migrated Database in SQL Server Management Studio
The first place we will review our migrated database will be from our current position within the SQL Server Management Studio.
1. Expand the Databases folder that appears in the Object Explorer pane, underneath the Analysis Services server within which we are working, on the left side of the Management Studio.
The Analysis Services databases in our local environment appear.
2. Select View --> Refresh, as depicted in Illustration 10, if the newly migrated FoodMart 2000 database does not appear immediately.
The Analysis Services databases in our local environment appear, including the new FoodMart 2000 database, similar to those shown in Illustration 11.
3. Expand the new FoodMart 2000 database.
4. Expand the Cubes folder.
We can easily review the entire structure of the database here, simply by expanding the database, and subsequently expanding the underlying folders, as depicted in Illustration 12.
5. Right-click the Sales cube in the FoodMart 2000 database Cubes folder.
6. Select Properties from the context menu that appears, as shown in Illustration 13.
The Properties page for the Sales cube appears, as depicted in Illustration 14.
We can examine the underlying properties of each of the cube and other database objects in this fashion. While we can make modifications, deletions and so forth within the Management Studio, the Business Intelligence Development Studio is often the better option for design and development within the context of an integrated business intelligence solution, whether working with a migrated Analysis Services database, or creating such a database from scratch.
7. Click OK to close the Properties page.
Let's go to the Business Intelligence Development Studio next, and get an introduction in opening our newly migrated database there.
8. Select File --> Exit from the main menu, as shown in Illustration 15, to close the SQL Server Management Studio.