Hello!
I need to move an OLAP cube from one SQL Server 2005 to another. I'm pretty new in this and I wonder if it is possible and if it is, then how
Thanks a lot!!
/Natasha
How to move an OLAP cube to another SQL Server 2005?
Hot Topic
- CREATE Credential Secret Storage
- Obtaining TCP/IP Port and Pipe name
- FastLoadMaxInsertCommitSize for Data Flow Destinations
- Newbie question - how do I specify a variable for the file location when using the Execute Package Task
- SQL Servers Communicating Across a DMZ
- Failed to generate a user instance of SQL Server
- How to setup a dataflow which validates before writing to a destination ?
- Datetime behavior
- strange refresh of the parameter area
- What exactly can sp_executesql parametrize?
SQL Server
- Connecting to Oracle on 64-bit (x64) machine
- Printing report produces .25 inch horizontal offset
- Bizarre Stored Procedure Behavior
- sql server management studio nov ctp
- SP3 Upgrade seems to have disconnected our Analysis Manager
- WMI Error 0x80041010
- Migrating from sql2000 MSDE database to sql2005 express - attach database errors
- SQL Server 2005 Express - ISO download ?
- Scheduling a legacy DTS package
- Using equal operator in transact-SQL for ntext datatype column
How to move an OLAP cube to another SQL Server 2005?
Dan Mikkelsen
Jacob Grass
roy-roy
Hi,
You can use a backup. After the restore you should double check the Data Sources if the underlying databases changed too. You can also generate an XML/A script (right mouse click on the database, Script database as, Create To in the SQL Server Management Studio) and execute it on the other server plus reprocessing.
Regards,
Bertil