Deploy Cubes

Hi

I want to deploy a complete analysis db (with the cubes and dimension) to another server. As I have learned it is possible to use backup and restore. But with this method also the data is transferred which is quite a headache when the cubes are already processed and contain a lot of data. Is it possible to just export the definition. Btw: It's analysis services 2000.

Thanks in advance

Thomas

Nobody?

Your answer would be greatly appreciated.

Thomas

|||

I think copy-paste in Analysis Manager would do the trick.

B.

|||

Hi Brian

Thanks for your reply. I will try it.

But one question to that. Copy paste method is not very friendly in a bigger scenario, where one developer creates the cubes and some companies on other location will use it. Also backup is not possible this way.

What are the methods to achieve this?

Regards

Thomas

|||

The options with AS 2000 are pretty weak. You can either backup & restore or copy-paste & reprocess. One variation is to backup an empty database, restore it, then reprocess.

In 2005, you can migrate changes through scripts. Some change will require reprocessing, but many do not.

B.

|||

Ok, thanks a lot.

Regards

Thomas