Archive restore cube between different servers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Archive restore cube between different servers

Hello, 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. Denis
]]>