SQL Server Performance Forum – Threads Archive
Copy Cube to a new DBI create a new database on AS, and want to copy some existing cubes to this new database. How can I do the copy? Thanks,
Check: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1146883,00.html Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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?
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.