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.
Illustration 10: Refresh
the Object Explorer as Necessary ...
The Analysis Services
databases in our local environment appear, including the new FoodMart 2000
database, similar to those shown in Illustration 11.
Illustration 11: FoodMart
2000 Appears Among the Analysis Services Databases
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.
Illustration 12: Objects
Making Up the Migrated FoodMart 2000 Database ...
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.
Illustration 13: Open
the Properties Page for the Sales Cube
The Properties page
for the Sales cube appears, as depicted in Illustration
14.
Illustration 14: Example
Properties Page for a Database Object
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.
Illustration 15: Leaving
SQL Server Management Studio ...
IE 7
Firefox 2.0