|
Home > Archive > MS SQL Server OLAP > December 2005 > Data Source issue when copying Cubes from one server to another
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Data Source issue when copying Cubes from one server to another
|
|
|
| Hi,
I've two DW servers (production, development). I want to make sure that my
development dw server is update with the production. Everynow and then I
change cube details on the production dw server but when I "copy cube from
production to development" or "restore production dw on development dw" a
data source pointing to prodution dw gets created on the development server
and all the cubes are pointing to the production data source. I've changed
the data source details in partitions but when i try to process the cubes it
fails. Also If i edit the cube i can see that priate dimensions are still
pointing to production server. Does the cube need to be processed
successfully to apply data source changes from partions to dimensions?
Or is there any other way to maintain two dw on production and development
sync with each other?
--
Regards,
Vivek
| |
| Darren Gosbell 2005-12-20, 7:23 am |
| You should not need to edit the connections for individual partitions in
this situation. You only need to change the settings for the shared data
source at the OLAP database level.
Note that you cannot change the name of the data source, so it will most
likely still have the name of your production server, but if you change
the underlying connection details all the objects in the database
(cubes/partitions/dimensions) will use these new details. The only
exception I can think of is if your production database has multiple
connection details for individual partitions, but that would be highly
unusual.
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <B57204F5-8EF3-479E-8656- CE4E5741D2FF@microso
ft.com>,
Vivek@discussions.microsoft.com says...
> Hi,
>
> I've two DW servers (production, development). I want to make sure that my
> development dw server is update with the production. Everynow and then I
> change cube details on the production dw server but when I "copy cube from
> production to development" or "restore production dw on development dw" a
> data source pointing to prodution dw gets created on the development server
> and all the cubes are pointing to the production data source. I've changed
> the data source details in partitions but when i try to process the cubes it
> fails. Also If i edit the cube i can see that priate dimensions are still
> pointing to production server. Does the cube need to be processed
> successfully to apply data source changes from partions to dimensions?
>
> Or is there any other way to maintain two dw on production and development
> sync with each other?
>
>
|
|
|
|
|