Hi there,

I'm implementing a development environment to streamline the release process
of the development work.

I've got the the test environment working now but I'm not sure how to keep
the data upto date in the test system with production system. Basically I've
restored the backup of the production OLAP db on to test server but now the
data source is still pointing to production server rather than the test
server. Also if I try to modify data source setup for each cube-partitions
than I loose the addtional measures that have been created in the test sytem,

Can anyone suggest an alternative for my problem?
--
Regards,

Vivek

You should not need to change the data source at the partition level.
Changing the connection for the shared data source should be all you
need to do. The data source will still have the name of the production
system, but you can change the underlying connection details.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <E0770DDD-4EB1-4708-8246-6ACC3F6E8474 (AT) microsoft (DOT) com>,
Vivek (AT) discussions (DOT) microsoft.com says...