locked
Deploying an SSAS cube with a different name on same server RRS feed

  • Question

  • Hi,

    How can i deploy an existing cube with a new name on the same server?

    Friday, June 21, 2013 3:18 PM

Answers

  • Hi Mayank,

    We can directly rename SSAS database name in our SSAS project. Here is an article for your reference, please see:
    Deploying an Analysis Services Project: http://technet.microsoft.com/en-us/library/ms166576(v=sql.110).aspx

    We can also use Deployment Wizard tool to generate XMLA deployment script. Then, we can directly create the cube by using the XMLA script. For more information, please see:
    Analysis Services Deployment Methods: http://technet.microsoft.com/en-us/library/ms175446(v=sql.105).aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Sunday, June 30, 2013 1:29 AM
    Sunday, June 23, 2013 6:57 AM
  • You can rename an ssas database by simply right clicking on the database in SQLSMS and selecting rename.  However, this only changes the name, not the databaseid.  So be careful.  Further explanation on http://richardlees.blogspot.com.au/2009/06/analysis-services-database-name-and.html

    There are two ways to recreate the same ssas database with different names (and new DatabaseIds).

    1. Backup the ssas database and restore as a new name (the new DatabaseId will be the same as the new name).
    2. Create an xmla deployment script for the database using either, the SSAS deployment wizard, or, if need be use Visual Studio to create a solution for the existing database, change the deployment properties to point to a new database name (ensure DatabaseId is also changed) and deploy.

    http://richardlees.blogspot.com.au


    Richard

    • Marked as answer by Elvis Long Sunday, June 30, 2013 1:29 AM
    Monday, June 24, 2013 5:04 AM

All replies

  • Hi Mayank,

    We can directly rename SSAS database name in our SSAS project. Here is an article for your reference, please see:
    Deploying an Analysis Services Project: http://technet.microsoft.com/en-us/library/ms166576(v=sql.110).aspx

    We can also use Deployment Wizard tool to generate XMLA deployment script. Then, we can directly create the cube by using the XMLA script. For more information, please see:
    Analysis Services Deployment Methods: http://technet.microsoft.com/en-us/library/ms175446(v=sql.105).aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Sunday, June 30, 2013 1:29 AM
    Sunday, June 23, 2013 6:57 AM
  • You can rename an ssas database by simply right clicking on the database in SQLSMS and selecting rename.  However, this only changes the name, not the databaseid.  So be careful.  Further explanation on http://richardlees.blogspot.com.au/2009/06/analysis-services-database-name-and.html

    There are two ways to recreate the same ssas database with different names (and new DatabaseIds).

    1. Backup the ssas database and restore as a new name (the new DatabaseId will be the same as the new name).
    2. Create an xmla deployment script for the database using either, the SSAS deployment wizard, or, if need be use Visual Studio to create a solution for the existing database, change the deployment properties to point to a new database name (ensure DatabaseId is also changed) and deploy.

    http://richardlees.blogspot.com.au


    Richard

    • Marked as answer by Elvis Long Sunday, June 30, 2013 1:29 AM
    Monday, June 24, 2013 5:04 AM
  • One more approach we tried today.

    In SSDT (former BIDS) create a new SSAS project using Import from server option.

    Now give the name you want for this project.

    Say our existing one is called "ABC". Give the new name say "ABC_NewOne".

    Viola! you will get a new SSAS project with the new database name.

    Notice the new name will automatically be shown in this our new project. Deploy this. 

    • Proposed as answer by Jennifer Zen Monday, December 23, 2019 9:32 AM
    Friday, November 6, 2015 8:41 PM