SQL Server Performance

Copy Cube to a new DB

Discussion in 'Analysis Services/Data Warehousing' started by beaniebear, Dec 6, 2005.

  1. beaniebear New Member

    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
  2. Luis Martin Moderator

    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.



  3. Raulie New Member

    As far as I know you right click copy paste.

    Raulie


  4. ranjitjain New Member

    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.

Share This Page