We need to deploy a number of cubes that have the same structure but
different data sources.
Is there any way of transfering a cubes structure between two machines and
then changing the datasource at the other end.
Thanks
Ben Gidley
Is there any way of transfering a cubes structure between two machines and
then changing the datasource at the other end.
Thanks
Ben Gidley
To transfer the cubes, archive them from the source machine, then restore
the resulting .CAB file onto the target machine.
To change the data source, don't define a new "Data Source". Instead, at
each target machine, in your restored cube database, edit the properties of
the "Data Source" that your original cube used. In this editing, you can
specify a totally different source database et al.
E.g., the "Data Sources" defined in a cube database are actually just a
level of indirection to a real data source. Your cubes/dimensions are
defined in terms of that cube database's "Data Sources", but you can alter
those data sources to point at different back-end systems.
Quote:> We need to deploy a number of cubes that have the same structure but
> different data sources.
> Is there any way of transfering a cubes structure between two machines and
> then changing the datasource at the other end.
> Thanks
> Ben Gidley
Quote:> We need to deploy a number of cubes that have the same structure but
> different data sources.
> Is there any way of transfering a cubes structure between two machines and
> then changing the datasource at the other end.
> Thanks
> Ben Gidley
Get hold of the SQL Server 2000 resource kit - it has an addin that allows
you to script the entire database/cube to a .vbs file - which can then of
course be modifed and run where ever you wish.
Best Regards
Trevor Dwyer - SQL Server MVP
Quote:> We need to deploy a number of cubes that have the same structure but
> different data sources.
> Is there any way of transfering a cubes structure between two machines and
> then changing the datasource at the other end.
> Thanks
> Ben Gidley
1. Changes to cube structure will it cause data deletion from the cube
If we make changes to the cube structure like adding a new dimension
or measure. Will it result in data from the cube being deleted. How
can we avoid the data from being deleted when the cube is modified.
Thanks
Samantha
2. Pointers for scripting OS X Save to PDF
3. Problems transfering a cube to a new server
6. DTS package runs slowly from job
7. Cube structure is invalid or Fact table size cannot be 0
9. Table structure to create cube
10. Invalid Object structure while processing Dimensions and cubes
12. cube structure
13. Archiving Cube Structure, but not data