Copy cube from a DB to another one

Hi,

I would like to copy a cube and its content from a database to another one.

The first database is the one used for production and the second will be used to archive the old cubes.

Is there a specific way to deal with this kind of issue ?

Thanks in advance for your support.

Rgds,

Juan

Hello! You have not told about what version you are using, AS2000 or SSAS2005?

With SSAS2005 you simply change this is the properties of the project and deployment.

This is in the solution explorer of BI-Developer Studio.

In AS2000 you can use archive and restore from one machine to another as long as the data source name is the same.

Regards

Thomas Ivarsson

|||In SSAS 2005, you also can try the new feature 'synchronize'.|||

I am using SSAS 2005. Can you tell me more about the "synchronize" feature.

Also, is there a way using xmla scripts ?

Cheers,

Juan

|||

You can take a look at the following link for "synchronize".

http://msdn2.microsoft.com/en-us/library/ms174928.aspx

Yes. It supports xmla script. The easy way is to generate the script using the synchronize wizard.

|||Thx !