Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Rename a Multidimensional Database (Analysis Services)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

The manner in which you change the name of a Microsoft SQL Server Analysis Services database depends upon how you connect to the Analysis Services database. To change the name of an existing database, you must connect in online mode. To change the name of the database into which objects in an Analysis Services project will be instantiated, you must connect in project mode.

To change the database name in online mode

  1. Using SQL Server Data Tools, connect directly to the Analysis Services database.

  2. In Solution Explorer, right-click the database and then click Edit Database.

  3. In the Database name text box, change the database name.

  4. Click Save or Save All on the toolbar, click Save Selected Items or Save All on the File menu, or close the Database Designer and then click Save when prompted.

    The database name is updated in the Analysis Services instance and the database object in Solution Explorer is refreshed.

To change the database name in project mode

  1. Open the Analysis Services project.

  2. In Solution Explorer, right-click the Analysis Services project and then click Properties.

  3. In the Property Pages dialog box, click Deployment in the Configuration Properties section.

  4. Change the Database property to the new database name.

    The next time the Analysis Services project is deployed, it will be deployed to this new database name. If this database already exists, it will be overwritten.

To change the database name using SQL Server Management Studio

  • Right-click the Analysis Services database and edit the Name property.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft