Readme for Analysis Services Upgrade Verification Tool Sample

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.
The Analysis Services Upgrade Verification Tool lets you compare Multidimensional Expressions (MDX) query results and performance between a Microsoft SQL Server 2000 Analysis Services database and a Microsoft SQL Server 2005 Analysis Services (SSAS) database. This tool helps you verify that your upgrade from SQL Server 2000 to SQL Server 2005 was successful.

Scenario

This sample allows you to verify the validity and correctness of your data after an upgrade from SQL Server 2000 to SQL Server 2005.

Languages

C#

Prerequisites

Before you run this sample, you should have the following software installed:
  • .NET Framework SDK 2.0 or Microsoft Visual Studio 2005. The .NET Framework SDK is available free of charge. For more information, see Installing the .NET Framework SDK in SQL Server 2005 Books Online.
  • ADOMD.NET. This API is available free of charge in the Feature Pack for Microsoft SQL Server 2005 on the Microsoft Web site.
*

Analysis Services
  • Business Intelligence Development Studio Note: Business Intelligence Development Studio is not supported on computers that run the Itanium-based operating system; the 64-bit development environment is supported on x64-based operating systems. SQL Server samples can be modified and run on computers that run either x86 or x64-based operating systems when databases used by the samples are deployed on an Itanium-based operating system.
  • The Analysis Services Upgrade Verification Tool sample. You can download this sample from the Microsoft SQL Server Samples and Community Projects Web site at Microsoft SQL Server Samples and Community Projects. For more information about how to download and install samples, see Installing SQL Server Samples and Sample Databases in SQL Server Books Online.

Building the Sample

To build the ASUV sample
  • Build the sample by using Visual Studio 2005 and the provided Visual Studio solution.— or —
  • Build the sample by using Microsoft MSBuild, which is included in the .NET Framework SDK 2.0. At a command prompt, run a command similar to the following:msbuild /nologo /verbosity:quiet /property:Configuration=Debug CS/ASUV.slnOther Microsoft MSBuild build options can be used depending on your needs.

Running the Sample

To run the ASUV sample
  • In Visual Studio 2005, press F5.— or —
  • In Visual Studio 2005, on the Debug menu, click Start. — or —
  • At a command prompt, run a command similar to the following:CS\ASUV\bin\Debug\ASUV.exeThe path might vary depending on the options that were used to compile the sample and the starting folder when at command prompt.

Opening the sample project

To open the sample project
  1. On the File menu, click Open.
  2. In the Project Location box, enter the location of the sample project XML file. For example, the path might be similar to the following: CS\ASUV\SampleProject.xml
  3. Test the database connections by clicking Test Connection.
  4. Click Apply.

Adding and executing the sample queries

To add and execute the sample queries
  1. On the Query menu, click Add Query.
  2. In the Select File box, enter the location of the sample queries MDX file. For example, the path might be similar to the following: CS\ASUV\SampleQueries.mdx
  3. Click Import.
  4. On the Query menu, click Execute Queries AS 2000 or* Execute Queries AS 2005*.
  5. To view the query results, on the Result menu, click Compare Query Results.

Getting more help

To open the ASUV sample online help
  • On the Help menu, click Help Topics. © 2007 Microsoft Corporation. All rights reserved.

Last edited Aug 15, 2007 at 2:04 AM by bonniefe, version 4

Comments

No comments yet.