May 9, 2002 at 9:45 am
In SQL2000 EE we have created a cube based on an OLE DB connection to a test Oracle database.
We now have to promote this cube to production which requires us to make a copy
of the cube, change the OLE DB connection to the production Oracle database
and reprocess the cube. We have only 1 instance of MS Analysis.
What are the steps involved in doing this migration, especially when it comes to
pointing the copied cube to another Oracle database ?
This should be a standard requirement and is there a document that outlines the steps involved ?
If we decided to have separate production, development and test instances of MS Analysis, how would
the same be done ?
May 21, 2002 at 8:04 am
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
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
Paul.Ibison@replicationanswers.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply