Databases Reference
In-Depth Information
in building applications, then your applications might also have to be updated
accordingly. Please plan to spend time to ensure all your applications are
working for your customers after the upgrade process. We also have an
experienced-based general recommendation — test the entire upgrade pro-
cess on a test machine. In this way, you can verify if your existing applications
are working as expected using the Analysis Services 2005 instance. Finally,
with confidence you can perform the upgrade on your production machine.
If you do not have a test machine we recommend the following approach: In-
stall Analysis Services 2005 as a named instance. Analysis Services 2005
provides you with a wizard to migrate your databases from an Analysis Ser-
vices 2000 server to an Analysis Services 2005 instance. Analysis Services
2005 provides you with an integrated environment to manage all SQL Server
2005 products using SQL Server Management Studio (SSMS). SSMS is the
newer version of the famous Query Analyzer, which is available in SQL Serv-
er 2000.
In the following short tutorial, we will reference Foodmart2000 as a sample
database and you can use your own databases where appropriate. To mi-
grate your Analysis Services 2000 databases to an Analysis Services 2005
instance, follow these steps:
1. Launch SQL Server Management Studio, which comes with Analysis
Services 2005, by choosing from the Start Menu All Programs
Microsoft SQL Server2005 SQL Server Management Studio. Con-
nect to the Analysis Services 2005 instance using SQL Server Man-
agement Studio's Object Explorer. Right-click the server name and
select Migrate Database as shown in
Figure 2-6
.
This takes you to
the welcome screen of the wizard. If someone else had used this
wizard and disabled the welcome page you might not see the wel-
come page. If you are in the welcome page click the next button to
proceed to step 2.
Search WWH ::
Custom Search