SQL Server Performance

Archive restore cube between different servers

Discussion in 'Analysis Services/Data Warehousing' started by dennebom, Nov 30, 2005.

  1. dennebom New Member

    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

Share This Page