Migrating cubes between 2 servers

Last Post 29 Nov 2005 04:06 AM by dennebom. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

29 Nov 2005 04:06 AM

I've got two different environments. A production and development, those two are on different servers.
I connect with the two servers on client server base. I don't work directly on the 2 server machines.
When I'm done with my datamart I want to migrate my develop datamart to the production datamart.
But when I archive my datamart on development and I restore the CAB file on production I get a Data Source Error. That's normal because the datasource is set on de development data source. When I change that on the production server to the production data source, I got errors with processing the cubes on prodction because with some dimensions he cannot find the datasource.

Does someone had the same problem?
How can I solve it. Changing the data source to localhost isn't a option because I work client server.

Thnx for the Help allready.


Acceptable Use Policy