SQL Server Performance

SQL server Analysis services

Discussion in 'Analysis Services/Data Warehousing' started by surya_sudheer, Oct 16, 2006.

  1. surya_sudheer New Member

    Export of cube from SQL server?
    Import of cube into SQL server?
    Address of the cube where it is stored in destination after exporting?
    When we create a cube by using the data from oracle as a backend we want to export the cube to another sql server. what is the process and what is the destination in another server in which the cube is exported?

    sudheer
    surya_sudheer, Oct 16, 2006
    #2

  2. ranjitjain New Member

    hi, can you please elaborate more on your issue.
    what do you mean by exporting cube and address in sql server
    ranjitjain, Oct 16, 2006
    #2

  3. ranjitjain New Member

    Hi,
    Do you mean creating the dev Analysis database on to a test server.
    You can go for either of following options in MSAS2000.
    1>Backup and restore cab file
    2>Create meta data script on dev and run it on test server
    ranjitjain, Oct 17, 2006
    #2

Share This Page