Skip to content

rename-a-multidimensional-database-analysis-services.md

Latest commit

 

History

History
53 lines (36 loc) · 3.1 KB

rename-a-multidimensional-database-analysis-services.md

File metadata and controls

53 lines (36 loc) · 3.1 KB
title Rename a Multidimensional Database (Analysis Services) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology analysis-services
ms.topic conceptual
helpviewer_keywords
renaming databases
ms.assetid 15fdaec7-f3e4-44d9-9b78-1a1d78c484e0
author minewiskan
ms.author owend
manager craigg

Rename a Multidimensional Database (Analysis Services)

The manner in which you change the name of a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] database depends upon how you connect to the [!INCLUDEssASnoversion] 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 [!INCLUDEssASnoversion] project will be instantiated, you must connect in project mode.

To change the database name in online mode

  1. Using [!INCLUDEssBIDevStudio], connect directly to the [!INCLUDEssASnoversion] 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 [!INCLUDEssASnoversion] instance and the database object in Solution Explorer is refreshed.

To change the database name in project mode

  1. Open the [!INCLUDEssASnoversion] project.

  2. In Solution Explorer, right-click the [!INCLUDEssASnoversion] 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 [!INCLUDEssASnoversion] 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 [!INCLUDEssASnoversion] database and edit the Name property.

See Also

Configure Server Properties in Analysis Services
Set Multidimensional Database Properties (Analysis Services)
Configure Analysis Services Project Properties (SSDT)
Deploy Analysis Services Projects (SSDT)