How to import cube definition from SSAS 2000 to SSAS 2005

Hot Topic

Expressions
Remote Connection problem on MS SQL 2000
Database Summary Reports
which sp1 do I pick?
Cannot Start SQL Server Database Services - SQL Server Express April CTP
SQLExpress database fails under SQL SERVER 2005
@variable in SELECT ... WHERE ... IN clause
Single Parameter/Multiple ORs
SQL Reporting Services and SiteMinder (SSO product by Netegrity)
Database on webserver accessible through excel

SQL Server

Best way to make a database not in use?
server problem occurred during deployment of vb.net application with MSSQL db
failure installing SQL Server 2005
The specified SQL Server could not be found?
sql server 2005 SSIS and AS400 connectivity
Model Information
Import Export Wizard - ODBC to SQL
Stumped...JOIN with a DatePart on a field name...
Problem with Dependencies and Default Values
UK Datetime parameter problem SQL 2005 RS

How to import cube definition from SSAS 2000 to SSAS 2005

Hi.
I have a SSAS project CAB-file created in SSAS2000 and would like to import/convert it to a SSAS2005 project but I can't find any way to do this... Does anybody know how this is done  Any suggestions would be greatly appreciated!

Regards
Kjetil

Answer this question

How to import cube definition from SSAS 2000 to SSAS 2005

  • Chris G

    Hello Adrian,

    Thanks for your reply.

    My first server (SQL 2000), SERVER#1 is on domain AAA.DOMAIN.COM
    My second server (SQL 2005), SERVER#2 is on domain BBB.DOMAIN.COM

    The message I get is: Source server:  The following system error occurred:  A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

    Any suggestions

    Why not just easy use the .CAB file

    Thanks in advance,
    Marco.

  • basedissonance

    AS2005 won't read the backup files produced in AS2000, but AS2005 comes with MigrationWizard.exe that can be used. You will need to:
    - have AS2000 running and containing the database you want to migrate
    - run MigrationWizard.exe, specify the source AS2000 and then you can decide to migrate directly to an AS2005 or to just generate the migration script (and XML/A script that you can later run on AS2005 with SQL Management Studio)
    - you will need to reprocess the database on AS2005

    Adrian.

  • Ideefiks

    Hi,
    The error occurs in the validation page (where there is a tree with the AS2000 objects) or on the next page (migration page - where the script is being sent to AS2005)
    Can you please post the error Or the log if the error occured in the validation page (there are some buttons under the tree, one can be used to get the log).

    Thank you,
    Adrian Dumitrascu.

  • Anish George

    Hello Adrian,

    I tried your solution but I still have a problem.

    In my case the MSAS 2000 (with cubes) is on a separate server. I can connect and start the wizard but when the wizard is checking the data source it fails.

    CONFIG:
    Server #1: MS SQL Server 2000 (SP4) + MS AS 2000 (SP4)

    Server #2: MS SQL Server 2005 + MS AS 2005

    I have a local account on Server #1 and a local account on Server #2. Both same name + password.

    The DTS-wizard is working fine, but the MSAS migrationwizard not.

    Any ideas

    Thanks in advance for any help.
    Marco.

  • PDeFeo

    Thank you!
    Sorry for the delayed reply but I'be been rather busy lately.
    I am starting on this project next week and will try out your suggestions.

    Best regards
    Kjetil Smile
  • How to import cube definition from SSAS 2000 to SSAS 2005
Answer this question