August 31, 2004 at 10:44 am
Hi,
Is there a way to move a Cubes from one server to another without using the Archiving/Restore mechanism, nor restarting the Analysis Services on the target?
For the later solution here is a good link http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=moving+cubes&dg=microsoft.public.sqlserver.olap&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=&sloc=en-us. However, restarting the Analysis Services in the target server is not a solution.
Thanks in advance.
September 1, 2004 at 9:45 pm
Why? Is it an issue of the underlying data for the relational cube no longer existing?
If not, your best bet is to copy/paste (as empty DB)/archive/restore/reprocess on the new server.
Just my .02
Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)
Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm
September 3, 2004 at 2:23 am
The ideia is to copy the cube from pre-production to production. This way no cube is generated/updated in production and of course I can not stop the production environment to use the 2nd solution.
The archive solution takes time to compress files that immediately after will be decompress to restore the cube in production. Besides some cab files already have above 1 GB, therefore creating those cab take unnecessary time.
September 3, 2004 at 2:23 pm
Hi,
What I was suggesting is you restore an empty OLAP DB schema to your production server and re-process your cube. There is no requirement to stop and restart a server when doing so.
The way you get an empty schema is to copy and paste the entire OLAP DB as a new DB name, Archive the empty DB and then restore it on the production box.
I've used this approach a countless number of times and unless your cube is huge dozens of gig you should be able to re-process within an hour at most.
Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)
Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply