升級 Data Quality ServicesUpgrade Data Quality Services

本主題提供有關如何將您現有的 Data Quality Services (DQS) 安裝升級至 SQL Server 2014SQL Server 2014 CTP2。This topic provides information on how to upgrade your existing installation of Data Quality Services (DQS) to SQL Server 2014SQL Server 2014 CTP2. 將 DQS 中的資料品質伺服器升級至 SQL Server 2014SQL Server 2014的過程中,您也必須升級 DQS 資料庫結構描述。As part of upgrading your Data Quality Server in DQS to SQL Server 2014SQL Server 2014, you must also upgrade the DQS databases schema.

重要

  • 在升級 DQS 之前,您必須先備份 DQS 資料庫,以免在結構描述升級期間有任何意外的遺失資料狀況。You must back up your DQS databases before upgrading DQS to prevent any accidental data loss during the schema upgrade. 如需有關備份 DQS 資料庫的詳細資訊,請參閱 備份及還原 DQS 資料庫For information about backing up DQS databases, see Backing Up and Restoring DQS Databases.
  • 您可以使用最新或舊版 Data Quality Client 連接至 SQL Server 2014SQL Server 2014 版的 Data Quality Server 或 Integration Services 中的 DQS 清理轉換 ,以執行您的資料品質工作。You can connect to the SQL Server 2014SQL Server 2014 version of Data Quality Server by using the current or an earlier version of Data Quality Client or the DQS Cleansing Transformation in Integration Services to perform your data quality tasks.
  • 將 Data Quality Services 和 Master Data Services 升級為 SQL Server 2012SQL Server 2012 CTP2 之後,您可以繼續使用 SQL Server 2014SQL Server 2014 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 Data Quality Services and Master Data 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.

必要條件Prerequisites

  • 您必須以 Data Quality ServerData Quality Server 電腦上 Administrator 群組成員的身分登入。You must be logged on as a member of the Administrators group on the Data Quality ServerData Quality Server computer.

  • 您的 Windows 使用者帳戶必須是安裝 Data Quality ServerData Quality Server 之 SQL Server 執行個體上系統管理員 (sysadmin) 固定伺服器角色的成員。Your Windows user account must be a member of the sysadmin fixed server role in the SQL Server instance where Data Quality ServerData Quality Server is installed.

升級 DQSUpgrading DQS

升級 DQS:To upgrade DQS:

  1. 在開始升級程序之前,請先備份 DQS 資料庫。Back up your DQS databases before you start the upgrade process. 如需有關備份 DQS 資料庫的詳細資訊,請參閱備份及還原 DQS 資料庫For information about backing up DQS databases, see Backing Up and Restoring DQS Databases.

  2. 將安裝 DQS 的 SQL Server 執行個體升級至 SQL Server 2014SQL Server 2014Upgrade the SQL Server instance where DQS is installed to SQL Server 2014SQL Server 2014.

    1. 執行 SQL Server 2014SQL Server 2014 安裝精靈。Run 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 Setup wizard.

      注意

      如果 Data Quality Client 先前已安裝在這部電腦上,此作業會將您的 SQL Server 執行個體升級至 SQL Server 2014SQL Server 2014,而且也會安裝最新的 Data Quality Client。This will upgrade your SQL Server instance to SQL Server 2014SQL Server 2014 and also install the latest Data Quality Client, if Data Quality Client was previously installed on this computer. 如果您已將 Data Quality Client 安裝在其他電腦上,則必須在那些電腦上執行步驟 2 的子步驟,才能安裝 Data Quality Client 的目前版本。If you have Data Quality Client installed on other computers, you must run the sub steps in Step 2 on those computers to install the current version of Data Quality Client. 安裝精靈會將 Data Quality Client 的目前版本與 Data Quality Client 的現有版本並列安裝。The Setup wizard installs the current version of Data Quality Client alongside the existing version of Data Quality Client. 升級 DQS 資料庫結構描述之後,您可以使用最新或舊版 Data Quality Client 連接至 SQL Server 2014SQL Server 2014 版的資料品質伺服器。After you upgrade the DQS databases schema, you can connect to the SQL Server 2014SQL Server 2014 version of Data Quality Server by using the current or an earlier version of Data Quality Client.

  3. 升級 DQS 資料庫結構描述。Upgrade the DQS databases schema.

    1. 以系統管理員身分啟動命令提示字元。Start Command Prompt as an administrator.

    2. 在命令提示字元中,將目錄變更為 DQSInstaller.exe 所在的位置。At the command prompt, change your directory to the location where DQSInstaller.exe is available. 若為 SQL Server 的預設執行個體,DQSInstaller.exe 檔案位於 C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn:For the default instance of SQL Server, the DQSInstaller.exe file is available at C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn:

      cd C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn  
      
    3. 在命令提示字元中輸入下列命令,然後按 ENTER:At the command prompt, type the following command, and press ENTER:

      dqsinstaller.exe -upgrade  
      
    4. 安裝程式會提示您先備份 DQS 資料庫後再繼續。The installer prompts you for backing up the DQS databases before proceeding. 若已備份 DQS 資料庫,請輸入 YYes,然後按 ENTER 鍵繼續升級。If you have already backed up your DQS databases, type Y or Yes, and then press ENTER to continue with the upgrade.

    5. 在成功升級 DQS 資料庫結構描述之後,將會顯示完成訊息。A completion message is displayed after successful upgrade of the DQS databases schema.

確認 DQS 資料庫結構描述升級Verifying the DQS Databases Schema Upgrade

若要確認 DQS 資料庫結構描述升級成功,您可以查詢中每個資料庫中的 A_DB_VERSION 資料表,以檢查 DQS_MAIN 和 DQS_PROJECTS 資料庫中的目前版本。To verify that DQS databases schema have successfully upgraded, you can check the current version in the DQS_MAIN and DQS_PROJECTS databases by querying the A_DB_VERSION table in each database. 方法如下:To do so:

  1. 啟動 SQL Server Management Studio,並連接到包含已升級之 DQS 資料庫結構描述的 SQL Server 執行個體。Start SQL Server Management Studio, and connect to the SQL Server instance that contains the upgraded DQS databases schema.

  2. 執行下列查詢:Run the following query:

    SELECT * FROM DQS_MAIN.dbo.A_DB_VERSION WHERE STATUS=2;  
    SELECT * FROM DQS_PROJECTS.dbo.A_DB_VERSION WHERE STATUS=2;  
    
  3. 輸出會顯示每個升級項目和升級日期。The output will display an entry for each upgrade along with the date of the upgrade. 最新日期的最大 VERSION_ID 和 ASSEMBLY_VERSION 為目前版本。The maximum VERSION_ID and ASSEMBLY_VERSION on the latest date is the current version. STATUS 資料行中的值為 2 代表成功。A value of 2 in the STATUS column indicates success. 如果發生錯誤,錯誤會列示在 ERROR 資料行中。If an error has occurred, the error will be listed in the ERROR column. 範例輸出:A sample output:

    IDID UPGRADE_DATEUPGRADE_DATE VERSION_IDVERSION_ID ASSEMBLY_VERSIONASSEMBLY_VERSION USER_NAMEUSER_NAME STATUSSTATUS errorERROR
    10001000 2013-08-11 05:26:39.5672013-08-11 05:26:39.567 12001200 11.0.3000.011.0.3000.0 <網域\使用者名稱><DOMAIN\UserName> 22
    10011001 2013-09-19 15:09:37.7502013-09-19 15:09:37.750 16001600 12.0.xxxx.012.0.xxxx.0 <網域\使用者名稱><DOMAIN\UserName> 22

另請參閱See Also

安裝 Data Quality Services Install Data Quality Services
移除 Data Quality Server 物件 Remove Data Quality Server Objects
升級到 SQL Server 2014Upgrade to SQL Server 2014