Export (0) Print
Expand All

Readme for Analysis Services Upgrade Verification Tool Sample

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.

Default Location: C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Administrator\ASUV

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

Before you run this sample, you should have the following software installed:

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

    Other Microsoft MSBuild build options can be used depending on your needs.

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

    The path might vary depending on the options that were used to compile the sample and the starting folder when at command prompt.

  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.

  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.

  • On the Help menu, click Help Topics.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft