Post reply

Migrating Cubes from Test to Prod

  • May 21, 2002 at 8:04 am

    #429530

    Hi,

    I don't know a documented way to do this. All I can say is how

    I have done the same thing.

    I Archived the OLAP-Database and Restored it to another name.

    You can do a Copy and Paste operation, too.

    Now you can edit the Datasource Properties in the copied database and

    all should be fine if the datasources have the same tables and owners

    the cube were built from.

    Has anyone figured out a way to do this in the same OLAP-Database?

    With the table Replace function in the Cube-Editor I were not able to choose

    a table from another Datasource.

    Norbert

  • June 17, 2002 at 3:51 am

    #430989

    Norbert - how do you restore to another name? When I've tried to do this, I get the message "The database already exists on this server - do you want to overwrite?". Presumably the workaround is to do it programattically?

    Paul Ibison

    Paul.Ibison@blueyonder.co.uk


    Paul Ibison
    Paul.Ibison@replicationanswers.com

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply