Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Nov 21, 2005

Introduction to MSSQL Server Analysis Services: Migrating an Analysis Services 2000 Database to Analysis Services 2005 - Page 3

By William Pearson

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 ...

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM