Copy Cube to a new DB | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copy Cube to a new DB

I create a new database on AS, and want to copy some existing cubes to this new database. How can I do the copy? Thanks,
– Kathy
Check: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1146883,00.html Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
As far as I know you right click copy paste. Raulie

quote:Originally posted by beaniebear I create a new database on AS, and want to copy some existing cubes to this new database. How can I do the copy?
Thanks,
– Kathy

As raulie said It’s fairly simple. Open Analysis Manager then right click the cube you need to copy and then paste them in new database. After this you need to process those copied cubes again for new DB as you will not be able to check data for those one.
Also make sure that the new db has those dimension whire are being called in cubes.
]]>