升級 Master Data ServicesUpgrade Master Data Services

升級至 Microsoft SQL Server 2014SQL Server 2014 CTP2 的情況有四種。There are four scenarios for upgrading to Microsoft SQL Server 2014SQL Server 2014 CTP2. 請選擇最適合您情況的情況。Choose the scenario that fits your situation.

重要

  • 不支援從 SQL Server 2014SQL Server 2014 CTP1 版本升級到 CTP2 版本。Upgrading from the SQL Server 2014SQL Server 2014 CTP1 release to the CTP2 release is not supported.
  • 在執行任何升級之前備份您的資料庫。Back up your database before performing any upgrade.
  • 升級程序會重新建立預存程序,並升級 Master Data ServicesMaster Data Services使用的資料表。The upgrade process recreates stored procedures and upgrades tables used by Master Data ServicesMaster Data Services. 您對這些元件所做的任何自訂可能會遺失。Any customizations you have made to either of these components may be lost.
  • 模型部署封裝只能在之前建立這些封裝的 [SQL Server]SQL Server 版本中使用。Model deployment packages can be used only in the edition of [SQL Server]SQL Server they were created in. 您無法部署中建立的模型部署封裝SQL Server 2008 R2SQL Server 2008 R2 / SQL Server 2012SQL Server 2012SQL Server 2014SQL Server 2014You cannot deploy model deployment packages created in SQL Server 2008 R2SQL Server 2008 R2/SQL Server 2012SQL Server 2012 to SQL Server 2014SQL Server 2014.
  • SQL Server 2012SQL Server 2012 將 Master Data Services 和 Data Quality Services 升級為 SQL Server 2014SQL Server 2014 CTP2 之後,您可以繼續使用 SP1 版適用於 Excel 的 Master Data Services 增益集。You can continue using the SQL Server 2012SQL Server 2012 SP1 version of Master Data Services Add-In for Excel after upgrading Master Data Services and Data Quality Services to SQL Server 2014SQL Server 2014 CTP2. 不過,在升級為 SQL Server 2014 CTP2 之後,任何舊版適用於 Excel 的 Master Data Services 增益集將無法運作。However, any earlier version of the Master Data Services Add-In for Excel will not work after upgrading to SQL Server 2014 CTP2. SQL Server 2012SQL Server 2012 您可以在 這裡下載 SP1 版適用於 Excel 的 Master Data Services 增益集。You can download the SQL Server 2012SQL Server 2012 SP1 version of Master Data Services Add-In for Excel from here.

升級但不包含 Database Engine 升級Upgrade without Database Engine Upgrade

這個情況可視為是並排顯示安裝,因為兩者SQL Server 2008 R2SQL Server 2008 R2 / SQL Server 2012SQL Server 2012SQL Server 2014SQL Server 2014以平行方式,在同一部電腦或不同的電腦上安裝。This scenario can be considered a side-by-side installation, because both SQL Server 2008 R2SQL Server 2008 R2/SQL Server 2012SQL Server 2012 and SQL Server 2014SQL Server 2014 are installed in parallel, on either the same computer or separate computers.

在此情況下,您會繼續使用 SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012 主控您的 MDS 資料庫。In this scenario you continue to use SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 to host your MDS database. 但是,您必須升級 MDS 資料庫的結構描述,然後建立 SQL Server 2014SQL Server 2014 Web 應用程式以存取 MDS 資料庫。However, you must upgrade the schema of the MDS database, and then create a SQL Server 2014SQL Server 2014 web application to access the MDS database. SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012 Web 應用程式無法再存取 MDS 資料庫。The MDS database can no longer be accessed by the SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 web application.

如果您選擇安裝SQL Server 2014SQL Server 2014和較早版本的 SQL Server (SQL Server 2008 R2SQL Server 2008 R2/SQL Server 2012SQL Server 2012) 的相同電腦上,則可以因為這些檔案會安裝在不同的位置。If you choose to install SQL Server 2014SQL Server 2014 and an earlier version of SQL Server (SQL Server 2008 R2SQL Server 2008 R2/SQL Server 2012SQL Server 2012) on the same computer, you can do so because the files are installed in a different location.

  • 根據預設,在 SQL Server 2014SQL Server 2014中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\120\Master Data Services。In SQL Server 2014SQL Server 2014, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\120\Master Data Services.

  • 根據預設,在 SQL Server 2012SQL Server 2012中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\110\Master Data Services。In SQL Server 2012SQL Server 2012, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\110\Master Data Services.

  • 根據預設,在 SQL Server 2008 R2SQL Server 2008 R2中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\Master Data Services。In SQL Server 2008 R2SQL Server 2008 R2, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\Master Data Services.

若要執行此工作,請完成下列步驟。To perform this task, complete the following steps.

  1. 安裝 Master Data ServicesMaster Data Services 及您想要的其他任何功能。Install Master Data ServicesMaster Data Services and any other features you want.

    1. 開啟 SQL Server 2014SQL Server 2014 安裝程式精靈。Open the SQL Server 2014SQL Server 2014 Setup wizard.

    2. 按一下左窗格中的 [安裝] 。In the left pane, click Installation.

    3. 按一下右窗格中的 [新增 SQL Server 獨立安裝或將功能加入至現有安裝] 。In the right pane, click New SQL Server stand-alone installation or add features to an existing installation.

    4. 在 [功能選擇] 頁面上,選取 [Master Data ServicesMaster Data Services] 以及您想要安裝的其他任何功能。On the Feature Selection page, select Master Data ServicesMaster Data Services and any other features you want to install.

    5. 完成精靈。Complete the wizard.

  2. 在安裝完成後,升級 MDS 資料庫結構描述。When the installation is complete, upgrade the MDS database schema.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

      重要

      若要升級 MDS 資料庫結構描述,您必須以建立 MDS 資料庫時指定之系統管理員帳戶的身分登入。To upgrade the MDS database schema, you must be logged in as the Administrator Account that was specified when the MDS database was created. 在 MDS 資料庫的 mdm.tblUser 中,這位使用者的 [識別碼] 值為 1In the MDS database, in mdm.tblUser, this user has the ID value of 1. 如需變更此使用者的資訊,請參閱變更系統管理員帳戶(Master Data Services)For information on changing this user, see Change the System Administrator Account (Master Data Services).

    2. 按一下左窗格中的 [資料庫組態] 。In the left pane, click Database Configuration.

    3. 在右窗格中,按一下選取的資料庫指定的資訊和您SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012資料庫執行個體。In the right pane, click Select Database and specify the information for your SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 database instance.

    4. 按一下 [升級資料庫] 可啟動 [升級資料庫精靈] 。Click Upgrade Database to start the Upgrade Database Wizard. 如需詳細資訊,請參閱升級資料庫精靈 (Master Data Services 組態管理員)For more information, see Upgrade Database Wizard (Master Data Services Configuration Manager).

  3. 升級完成後,請建立 SQL Server 2014SQL Server 2014 Web 應用程式。When the upgrade is complete, create a SQL Server 2014SQL Server 2014 web application.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

    2. 按一下左窗格中的 [Web 組態]In the left pane, click Web Configuration.

    3. 從右窗格的 [網站] 清單中,選取下列其中一個選項:In the right pane, from the Website list, select one of the following options:

      • [預設的網站] ,然後按一下 [建立應用程式] 。Default Web Site, then click Create Application.

      • [建立新的網站] 。Create new site. 建立網站時,便會自動建立新的 Web 應用程式。A new web application is automatically created when the website is created.

      重要

      在 SQL Server 2014 版的 Master Data Services 組態管理員中,可讓您選取您在舊版 SQL Server (SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012) 中的現有 MDS Web 應用程式。Your existing MDS web application from an earlier version of SQL Server (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) is available for selection in the SQL Server 2014 version of Master Data Services Configuration Manager. 您絕不能選取現有的 Web 應用程式,而是必須建立 MDS 的 SQL Server 2014SQL Server 2014 Web 應用程式。You must not select the existing web application, and instead must create a SQL Server 2014SQL Server 2014 web application for MDS. 否則,當您嘗試將 Web 應用程式與升級的 MDS 資料庫建立關聯時,將會收到錯誤,說明因為該頁面的相關組態資料無效,所以無法存取所要求的頁面。Otherwise, you will receive an error when you try to associate the web application with the upgraded MDS database stating that the requested page cannot be accessed because the related configuration data for the page is invalid.

      如果您要為 MDS Web 應用程式使用相同的名稱 (別名) 做為現有 (SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012) Web 應用程式,您必須先將 Web 應用程式和相關聯的應用程式集區從 IIS 刪除,然後使用 SQL Server 2014 版的 Master Data Services 組態管理員,以相同的名稱建立 Web 應用程式。If you want to use the same name (alias) for MDS web application as your existing (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) web application, you must first delete the web application and the associated application pool from IIS, and then create a web application with the same name using SQL Server 2014 version of Master Data Services Configuration Manager. 如需從 IIS 移除 Web 應用程式和應用程式集區的資訊,請參閱 移除應用程式 (IIS)移除應用程式集區 (IIS)For information about removing web application and application pools from IIS, see Remove an Application (IIS) and Remove an Application Pool (IIS).

  4. 現在將新的 Web 應用程式與升級的 MDS 資料庫建立關聯。Now associate the new web application with the upgraded MDS database.

    1. 在 [建立應用程式與資料庫間的關聯] 區段中,按一下 [選取] 。In the Associate Application with Database section, click Select.

    2. 選取 MDS 資料庫。Select the MDS database.

    3. 按一下 [套用]Click Apply.

升級且包含 Database Engine 升級Upgrade with Database Engine Upgrade

在此案例中,您要將資料庫引擎和 Master Data ServicesMaster Data Services 應用程式從 SQL Server 2008 R2SQL Server 2008 R2 或 SQL Server 2012 升級到 SQL Server 2014SQL Server 2014In this scenario you will upgrade both the database engine and Master Data ServicesMaster Data Services application from SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012 to SQL Server 2014SQL Server 2014.

若要執行此工作,請完成下列步驟。To perform this task, complete the following steps.

  1. 針對SQL Server 2008 R2SQL Server 2008 R2:開啟控制台中 > 程式和功能並解除安裝 Microsoft SQL Server 2008 R2SQL Server 2008 R2 Master Data ServicesMaster Data ServicesFor SQL Server 2008 R2SQL Server 2008 R2 only: Open Control Panel > Programs and Features and uninstall Microsoft SQL Server 2008 R2SQL Server 2008 R2Master Data ServicesMaster Data Services.

  2. 將資料庫引擎升級至 SQL Server 2014SQL Server 2014Upgrade the database engine to SQL Server 2014SQL Server 2014.

    1. 開啟 SQL Server 2014SQL Server 2014 安裝程式精靈。Open the SQL Server 2014SQL Server 2014 Setup wizard.

    2. 按一下左窗格中的 [安裝] 。In the left pane, click Installation.

    3. 在右窗格中,按一下從 SQL Server 2005,SQL Server 2008,SQL Server 2008 R2 或 SQL Server 2012 升級In the right pane, click Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012.

    4. 完成精靈。Complete the wizard.

  3. 針對SQL Server 2008 R2SQL Server 2008 R2:在升級完成時,新增 Master Data ServicesMaster Data Services 功能。For SQL Server 2008 R2SQL Server 2008 R2 only: When the upgrade is complete, add the Master Data ServicesMaster Data Services feature.

    1. 開啟 SQL Server 2014SQL Server 2014 安裝程式精靈。Open the SQL Server 2014SQL Server 2014 Setup wizard.

    2. 按一下左窗格中的 [安裝] 。In the left pane, click Installation.

    3. 按一下右窗格中的 [新增 SQL Server 獨立安裝或將功能加入至現有安裝] 。In the right pane, click New SQL Server stand-alone installation or add features to an existing installation.

    4. 安裝類型頁面的精靈中,選取將功能加入至現有的執行個體選項,然後選擇 安裝 MDS 資料庫的執行個體。On the Installation Type page of the wizard, select the Add features to an existing instance option, and choose the instance where MDS database is installed.

    5. 在上特徵頁面的 共用功能,選取 Master Data ServicesMaster Data ServicesOn the Feature Selection page, under Shared Features, select Master Data ServicesMaster Data Services.

    6. 完成精靈。Complete the wizard.

  4. 升級 MDS 資料庫結構描述。Upgrade the MDS database schema.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

      重要

      若要升級 MDS 資料庫結構描述,您必須以建立 MDS 資料庫時指定之系統管理員帳戶的身分登入。To upgrade the MDS database schema, you must be logged in as the Administrator Account that was specified when the MDS database was created. 在 MDS 資料庫的 mdm.tblUser 中,這位使用者的 [識別碼] 值為 1In the MDS database, in mdm.tblUser, this user has the ID value of 1. 如需變更此使用者的資訊,請參閱變更系統管理員帳戶(Master Data Services)For information on changing this user, see Change the System Administrator Account (Master Data Services).

    2. 按一下左窗格中的 [資料庫組態] 。In the left pane, click Database Configuration.

    3. 在右窗格中,按一下選取資料庫並指定您的資料庫執行個體的資訊。In the right pane, click Select Database and specify the information for your database instance.

    4. 按一下 [升級資料庫] 可啟動 [升級資料庫精靈] 。Click Upgrade Database to start the Upgrade Database Wizard. 如需詳細資訊,請參閱升級資料庫精靈 (Master Data Services 組態管理員)For more information, see Upgrade Database Wizard (Master Data Services Configuration Manager).

    5. 按一下 [套用]Click Apply.

  5. 升級完成後,請建立 SQL Server 2014SQL Server 2014 Web 應用程式。When the upgrade is complete, create a SQL Server 2014SQL Server 2014 web application.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

    2. 按一下左窗格中的 [Web 組態]In the left pane, click Web Configuration.

    3. 從右窗格的 [網站] 清單中,選取下列其中一個選項:In the right pane, from the Website list, select one of the following options:

      • [預設的網站] ,然後按一下 [建立應用程式] 。Default Web Site, then click Create Application.

      • [建立新的網站] 。Create new site. 建立網站時,便會自動建立新的 Web 應用程式。A new web application is automatically created when the website is created.

      重要

      SQL Server 2008 R2SQL Server 2008 R2 版的 Master Data Services 組態管理員中,可讓您選取您在舊版 SQL Server (SQL Server 2012SQL Server 2012SQL Server 2014SQL Server 2014) 中的現有 MDS Web 應用程式。Your existing MDS web application from an earlier version of SQL Server (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) is available for selection in the SQL Server 2014SQL Server 2014 version of Master Data Services Configuration Manager. 您絕不能選取現有的 Web 應用程式,而是必須建立 MDS 的 SQL Server 2014SQL Server 2014 Web 應用程式。You must not select the existing web application, and instead must create a SQL Server 2014SQL Server 2014 web application for MDS. 否則,當您嘗試將 Web 應用程式與升級的 MDS 資料庫建立關聯時,將會收到錯誤,說明因為該頁面的相關組態資料無效,所以無法存取所要求的頁面。Otherwise, you will receive an error when you try to associate the web application with the upgraded MDS database stating that the requested page cannot be accessed because the related configuration data for the page is invalid.

      如果您要為 MDS Web 應用程式使用相同的名稱 (別名) 做為現有 (SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012) Web 應用程式,您必須先將 Web 應用程式和相關聯的應用程式集區從 IIS 刪除,然後使用 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員,以相同的名稱建立 Web 應用程式。If you want to use the same name (alias) for MDS web application as your existing (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) web application, you must first delete the web application and the associated application pool from IIS, and then create a web application with the same name using SQL Server 2014SQL Server 2014 version of Master Data Services Configuration Manager. 如需從 IIS 移除 Web 應用程式和應用程式集區的資訊,請參閱 移除應用程式 (IIS)移除應用程式集區 (IIS)For information about removing web application and application pools from IIS, see Remove an Application (IIS) and Remove an Application Pool (IIS).

  6. 現在將新的 Web 應用程式與升級的 MDS 資料庫建立關聯。Now associate the new web application with the upgraded MDS database.

    1. 在 [建立應用程式與資料庫間的關聯] 區段中,按一下 [選取] 。In the Associate Application with Database section, click Select.

    2. 選取 MDS 資料庫。Select the MDS database.

    3. 按一下 [套用]Click Apply.

在兩部電腦的情況下升級Upgrade in Two-Computer Scenario

此情況包括升級在兩部電腦上安裝 SQL Server 的系統:一部安裝 SQL Server 2014SQL Server 2014,另一部安裝 SQL Server 2008 R2 或 SQL Server 2012。This scenario involves upgrading a system in which SQL Server is installed on two computers: one with SQL Server 2014SQL Server 2014, and the other with SQL Server 2008 R2 or SQL Server 2012.

如果安裝 SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012,則繼續分別使用 SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012,在一部電腦上裝載您的 MDS 資料庫。If SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 is installed, you continue to use SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 respectively to host your MDS database on one computer. 但是,您必須升級 MDS 資料庫的結構描述,然後使用 SQL Server 2014SQL Server 2014 Web 應用程式來存取 MDS 資料庫。However, you must upgrade the schema of the MDS database, and then use the SQL Server 2014SQL Server 2014 web application to access the MDS database. SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012 Web 應用程式無法再存取 MDS 資料庫。The MDS database can no longer be accessed by the SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 web application.

  • 根據預設,在 SQL Server 2014SQL Server 2014中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\120\Master Data Services。In SQL Server 2014SQL Server 2014, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\120\Master Data Services.

  • 根據預設,在 SQL Server 2012SQL Server 2012中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\110\Master Data Services。In SQL Server 2012SQL Server 2012, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\110\Master Data Services.

  • 根據預設,在 SQL Server 2008 R2SQL Server 2008 R2中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\Master Data Services。In SQL Server 2008 R2SQL Server 2008 R2, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\Master Data Services.

若要執行此工作,請完成下列步驟。To perform this task, complete the following steps.

  1. 安裝 Master Data ServicesMaster Data Services 及您想要的其他任何功能。Install Master Data ServicesMaster Data Services and any other features you want.

    1. 開啟 SQL Server 2014SQL Server 2014 安裝程式精靈。Open the SQL Server 2014SQL Server 2014 Setup wizard.

    2. 按一下左窗格中的 [安裝] 。In the left pane, click Installation.

    3. 按一下右窗格中的 [新增 SQL Server 獨立安裝或將功能加入至現有安裝] 。In the right pane, click New SQL Server stand-alone installation or add features to an existing installation.

    4. 在 [功能選擇] 頁面上,選取 [Master Data ServicesMaster Data Services] 以及您想要安裝的其他任何功能。On the Feature Selection page, select Master Data ServicesMaster Data Services and any other features you want to install.

    5. 完成精靈。Complete the wizard.

  2. 在安裝完成後,升級 MDS 資料庫結構描述。When the installation is complete, upgrade the MDS database schema.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

      重要

      若要升級 MDS 資料庫結構描述,您必須以建立 MDS 資料庫時指定之系統管理員帳戶的身分登入。To upgrade the MDS database schema, you must be logged in as the Administrator Account that was specified when the MDS database was created. 在 MDS 資料庫的 mdm.tblUser 中,這位使用者的 [識別碼] 值為 1In the MDS database, in mdm.tblUser, this user has the ID value of 1. 如需變更此使用者的資訊,請參閱變更系統管理員帳戶(Master Data Services)For information on changing this user, see Change the System Administrator Account (Master Data Services).

    2. 按一下左窗格中的 [資料庫組態] 。In the left pane, click Database Configuration.

    3. 在右窗格中,按一下 選取資料庫指定的資訊和您SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012資料庫的其他電腦上的執行個體,如果SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012另一部電腦上已安裝。In the right pane, click Select Database and specify the information for your SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 database instance on the other computer, if SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 is installed on the other computer.

    4. 按一下 [升級資料庫] 可啟動 [升級資料庫精靈] 。Click Upgrade Database to start the Upgrade Database Wizard. 如需詳細資訊,請參閱升級資料庫精靈 (Master Data Services 組態管理員)For more information, see Upgrade Database Wizard (Master Data Services Configuration Manager).

  3. 升級完成後,請建立 SQL Server 2014 Web 應用程式。When the upgrade is complete, create a SQL Server 2014 web application.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

    2. 按一下左窗格中的 [Web 組態]In the left pane, click Web Configuration.

    3. 從右窗格的 [網站] 清單中,選取下列其中一個選項:In the right pane, from the Website list, select one of the following options:

      • [預設的網站] ,然後按一下 [建立應用程式] 。Default Web Site, then click Create Application.

      • [建立新的網站] 。Create new site. 建立網站時,便會自動建立新的 Web 應用程式。A new web application is automatically created when the website is created.

      重要

      SQL Server 2008 R2SQL Server 2008 R2 版的 Master Data Services 組態管理員中,可讓您選取您在舊版 SQL Server (SQL Server 2012SQL Server 2012SQL Server 2014SQL Server 2014) 中的現有 MDS Web 應用程式。Your existing MDS web application from an earlier version of SQL Server (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) is available for selection in the SQL Server 2014SQL Server 2014 version of Master Data Services Configuration Manager. 您絕不能選取現有的 Web 應用程式,而是必須建立 MDS 的 SQL Server 2014SQL Server 2014 Web 應用程式。You must not select the existing web application, and instead must create a SQL Server 2014SQL Server 2014 web application for MDS. 否則,當您嘗試將 Web 應用程式與升級的 MDS 資料庫建立關聯時,將會收到錯誤,說明因為該頁面的相關組態資料無效,所以無法存取所要求的頁面。Otherwise, you will receive an error when you try to associate the web application with the upgraded MDS database stating that the requested page cannot be accessed because the related configuration data for the page is invalid.

      如果您要為 MDS Web 應用程式使用相同的名稱 (別名) 做為現有 (SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012) Web 應用程式,您必須先將 Web 應用程式和相關聯的應用程式集區從 IIS 刪除,然後使用 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員,以相同的名稱建立 Web 應用程式。If you want to use the same name (alias) for MDS web application as your existing (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) web application, you must first delete the web application and the associated application pool from IIS, and then create a web application with the same name using SQL Server 2014SQL Server 2014 version of Master Data Services Configuration Manager. 如需從 IIS 移除 Web 應用程式和應用程式集區的資訊,請參閱 移除應用程式 (IIS)移除應用程式集區 (IIS)For information about removing web application and application pools from IIS, see Remove an Application (IIS) and Remove an Application Pool (IIS).

  4. 現在將此 Web 應用程式與升級的 MDS 資料庫產生關聯。Now associate the web application with the upgraded MDS database.

    1. 在 [建立應用程式與資料庫間的關聯] 區段中,按一下 [選取] 。In the Associate Application with Database section, click Select.

    2. 選取 MDS 資料庫。Select the MDS database.

    3. 按一下 [套用]Click Apply.

包含從備份中還原資料庫的升級Upgrade with Restoring a Database from Backup

在這種情況中,SQL Server 2014SQL Server 2014 會隨著 SQL Server 2008 R2 或 SQL Server 2012 安裝在同一部電腦或兩部不同的電腦上。In this scenario, SQL Server 2014SQL Server 2014 is installed along with SQL Server 2008 R2 or SQL Server 2012 on the same computer or two different computers. 此外,資料庫會在升級之前,備份至 SQL Server 2014SQL Server 2014 CTP2 之前的版本上,而且資料庫必須還原。Also, a database was backed up on a version earlier than the SQL Server 2014SQL Server 2014 CTP2 release, prior to upgrade, and the database has to be restored.

  • 根據預設,在 SQL Server 2014SQL Server 2014中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\120\Master Data Services。In SQL Server 2014SQL Server 2014, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\120\Master Data Services.

  • 根據預設,在 SQL Server 2012SQL Server 2012中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\110\Master Data Services。In SQL Server 2012SQL Server 2012, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\110\Master Data Services.

  • 根據預設,在 SQL Server 2008 R2SQL Server 2008 R2中,檔案會安裝到 磁碟機:\Program Files\Microsoft SQL Server\Master Data Services。In SQL Server 2008 R2SQL Server 2008 R2, by default, the files are installed at drive:\Program Files\Microsoft SQL Server\Master Data Services.

若要執行此工作,請完成下列步驟。To perform this task, complete the following steps.

  1. 安裝 Master Data ServicesMaster Data Services 及您想要的其他任何功能。Install Master Data ServicesMaster Data Services and any other features you want.

    1. 開啟 SQL Server 2014SQL Server 2014 安裝程式精靈。Open the SQL Server 2014SQL Server 2014 Setup wizard.

    2. 按一下左窗格中的 [安裝] 。In the left pane, click Installation.

    3. 按一下右窗格中的 [新增 SQL Server 獨立安裝或將功能加入至現有安裝] 。In the right pane, click New SQL Server stand-alone installation or add features to an existing installation.

    4. 在 [功能選擇] 頁面上,選取 [Master Data ServicesMaster Data Services] 以及您想要安裝的其他任何功能。On the Feature Selection page, select Master Data ServicesMaster Data Services and any other features you want to install.

    5. 完成精靈。Complete the wizard.

  2. 還原備份的資料庫。Restore the database that was backed up.

  3. 在安裝完成後,升級 MDS 資料庫結構描述。When the installation is complete, upgrade the MDS database schema.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

      重要

      若要升級 MDS 資料庫結構描述,您必須以建立 MDS 資料庫時指定之系統管理員帳戶的身分登入。To upgrade the MDS database schema, you must be logged in as the Administrator Account that was specified when the MDS database was created. 在 MDS 資料庫的 mdm.tblUser 中,這位使用者的 [識別碼] 值為 1In the MDS database, in mdm.tblUser, this user has the ID value of 1. 如需變更此使用者的資訊,請參閱變更系統管理員帳戶(Master Data Services)For information on changing this user, see Change the System Administrator Account (Master Data Services).

    2. 按一下左窗格中的 [資料庫組態] 。In the left pane, click Database Configuration.

    3. 在右窗格中,按一下選取的資料庫指定的資訊和您SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012資料庫執行個體。In the right pane, click Select Database and specify the information for your SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 database instance.

    4. 按一下 [升級資料庫] 可啟動 [升級資料庫精靈] 。Click Upgrade Database to start the Upgrade Database Wizard. 如需詳細資訊,請參閱升級資料庫精靈 (Master Data Services 組態管理員)For more information, see Upgrade Database Wizard (Master Data Services Configuration Manager).

  4. 升級完成後,請建立 SQL Server 2014SQL Server 2014 Web 應用程式。When the upgrade is complete, create a SQL Server 2014SQL Server 2014 web application.

    1. 開啟 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員Master Data Services Configuration ManagerOpen the SQL Server 2014SQL Server 2014 version of Master Data Services 組態管理員Master Data Services Configuration Manager.

    2. 按一下左窗格中的 [Web 組態]In the left pane, click Web Configuration.

    3. 從右窗格的 [網站] 清單中,選取下列其中一個選項:In the right pane, from the Website list, select one of the following options:

      • [預設的網站] ,然後按一下 [建立應用程式] 。Default Web Site, then click Create Application.

      • [建立新的網站] 。Create new site. 建立網站時,便會自動建立新的 Web 應用程式。A new web application is automatically created when the website is created.

      重要

      SQL Server 2008 R2SQL Server 2008 R2 版的 Master Data Services 組態管理員中,可讓您選取您在舊版 SQL Server (SQL Server 2012SQL Server 2012SQL Server 2014SQL Server 2014) 中的現有 MDS Web 應用程式。Your existing MDS web application from an earlier version of SQL Server (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) is available for selection in the SQL Server 2014SQL Server 2014 version of Master Data Services Configuration Manager. 您絕不能選取現有的 Web 應用程式,而是必須建立 MDS 的 SQL Server 2014SQL Server 2014 Web 應用程式。You must not select the existing web application, and instead must create a SQL Server 2014SQL Server 2014 web application for MDS. 否則,當您嘗試將 Web 應用程式與升級的 MDS 資料庫建立關聯時,將會收到錯誤,說明因為該頁面的相關組態資料無效,所以無法存取所要求的頁面。Otherwise, you will receive an error when you try to associate the web application with the upgraded MDS database stating that the requested page cannot be accessed because the related configuration data for the page is invalid.

      如果您要為 MDS Web 應用程式使用相同的名稱 (別名) 做為現有 (SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012) Web 應用程式,您必須先將 Web 應用程式和相關聯的應用程式集區從 IIS 刪除,然後使用 SQL Server 2014SQL Server 2014 版的 Master Data Services 組態管理員,以相同的名稱建立 Web 應用程式。If you want to use the same name (alias) for MDS web application as your existing (SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012) web application, you must first delete the web application and the associated application pool from IIS, and then create a web application with the same name using SQL Server 2014SQL Server 2014 version of Master Data Services Configuration Manager. 如需從 IIS 移除 Web 應用程式和應用程式集區的資訊,請參閱 移除應用程式 (IIS)移除應用程式集區 (IIS)For information about removing web application and application pools from IIS, see Remove an Application (IIS) and Remove an Application Pool (IIS).

  5. 現在將新的 Web 應用程式與升級的 MDS 資料庫建立關聯。Now associate the new web application with the upgraded MDS database.

    1. 在 [建立應用程式與資料庫間的關聯] 區段中,按一下 [選取] 。In the Associate Application with Database section, click Select.

    2. 選取 MDS 資料庫。Select the MDS database.

    3. 按一下 [套用]Click Apply.

疑難排解Troubleshooting

問題: 當您開啟SQL Server 2008 R2SQL Server 2008 R2或是SQL Server 2012SQL Server 2012 主資料管理員Master Data Manager web 應用程式時,「 用戶端版本不相容的資料庫版本 」 的錯誤訊息。Issue: When you open the SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012主資料管理員Master Data Manager web application, a "client version is not compatible with the database version" error message is displayed.

解決方案: 就會發生此問題時SQL Server 2008 R2SQL Server 2008 R2或是SQL Server 2012SQL Server 2012主資料管理員 web 應用程式嘗試存取已升級為資料庫SQL Server 2014SQL Server 2014Master Data Services。Solution: This issue occurs when a SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 Master Data Manager web application tries to access a database that has been upgraded to SQL Server 2014SQL Server 2014 Master Data Services. 您必須改用 SQL Server 2014SQL Server 2014 Web 應用程式。You must use a SQL Server 2014SQL Server 2014 web application instead.

如果您升級 MDS 資料庫結構描述時,未在 IIS 中停止 [MDS 應用程式集區] 然後再重新啟動,也可能會發生此問題。This issue may also occur if you did not stop and restart the MDS Application Pool in IIS when upgrading the MDS database schema. 重新啟動 [MDS 應用程式集區] 即可更正此問題。Restart the MDS Application Pool to correct the issue.

另請參閱See Also

安裝 Master Data ServicesInstall Master Data Services