移除 Data Quality Server 物件Remove Data Quality Server Objects

Data Quality ServerData Quality Server 執行個體解除安裝 [SQL Server]SQL Server,或完整移除內含 [SQL Server]SQL ServerData Quality ServerData Quality Server 執行個體時,不會刪除某些 Data Quality ServerData Quality Server 物件,包括 DQS 資料庫。Uninstalling Data Quality ServerData Quality Server from an instance of [SQL Server]SQL Server, or completely removing an instance of [SQL Server]SQL Server that has Data Quality ServerData Quality Server does not delete some Data Quality ServerData Quality Server objects, including the DQS databases. 這意味著如果您使用 SQL Server 安裝程式解除安裝 Data Quality ServerData Quality Server ,就不會失去 DQS 資料。This implies that you do not lose your DQS data if you uninstall Data Quality ServerData Quality Server using the SQL Server setup. 您必須在完成解除安裝程序之後,手動刪除這些 Data Quality ServerData Quality Server 物件。You must manually delete these Data Quality ServerData Quality Server objects after the uninstall process is complete.

注意

  • 解除安裝 Data Quality ServerData Quality Server之前,請考慮將所有現有的知識庫匯出到 .dqsb 檔加以備份,並於之後使用該檔案將所有知識庫匯入到新的 Data Quality ServerData Quality Server 安裝中。Before uninstalling Data Quality ServerData Quality Server, consider backing up all your existing knowledge bases by exporting it to a .dqsb file, and use the file later to import all the knowledge bases back to a new Data Quality ServerData Quality Server installation. 您只能透過在命令提示字元中,執行 DQSInstaller.exe 搭配適當命令列參數的方式匯出和匯入所有 DQS 知識庫。Exporting and importing of all DQS knowledge bases can only be done by running DQSInstaller.exe with appropriate command line parameters from the command prompt. 如需詳細資訊,請參閱 使用 DQSInstaller.exe 匯出及匯入 DQS 知識庫For more information, see Export and Import DQS Knowledge Bases Using DQSInstaller.exe.
  • 刪除 DQS 資料庫之前,如果您要保留資料庫,請考慮備份該資料庫,並在稍後用於還原資料。Before deleting the DQS databases, consider backing up the databases if you want to preserve it, and use it later for restoring the data. 如需執行此作業的相關資訊,請參閱 管理 DQS 資料庫For information about doing so, see Manage DQS Databases.

從 SQLServer 執行個體解除安裝資料品質伺服器Uninstall Data Quality Server from a SQL Server Instance

如果您只要從 Data Quality ServerData Quality Server 執行個體解除安裝 [SQL Server]SQL Server,您必須在完成 Data Quality ServerData Quality Server 的解除安裝程序之後,手動從 [SQL Server]SQL Server 執行個體刪除下列 Data Quality ServerData Quality Server 物件:If you are just uninstalling Data Quality ServerData Quality Server from an instance of [SQL Server]SQL Server, you must manually delete the following Data Quality ServerData Quality Server objects from the [SQL Server]SQL Server instance after the Data Quality ServerData Quality Server uninstall process is complete:

  • DQS_MAIN、DQS_PROJECTS 和 DQS_STAGING_DATA 資料庫。DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases.

  • ##MS_dqs_db_owner_login## 和 ##MS_dqs_service_login## 登入。##MS_dqs_db_owner_login## and ##MS_dqs_service_login## logins.

  • master 資料庫中的 DQInitDQS_MAIN 預存程序。DQInitDQS_MAIN stored procedure from the master database.

您可以滑鼠右鍵按一下物件,然後按一下快速鍵功能表中的 [刪除] 來刪除 SQL Server Management Studio 中的這些物件。You can delete these objects in SQL Server Management Studio by right-clicking the object, and clicking Delete in the shortcut menu.

重要

如果您只要使用 -uninstall 命令列參數解除安裝 SQL Server 執行個體中的 Data Quality ServerData Quality Server,則在解除安裝過程中將刪除所有 DQS 物件。If you just uninstall Data Quality ServerData Quality Server from a SQL server instance using the -uninstall command line parameter from the command prompt, all the DQS objects are deleted as part of the uninstall process. 您不必在解除安裝 Data Quality ServerData Quality Server之後手動刪除這些物件。You do not have to delete them manually after uninstalling Data Quality ServerData Quality Server. 若要從命令提示字元解除安裝 Data Quality ServerData Quality Server ,請在命令提示字元中輸入下列命令,然後按 ENTER:To uninstall Data Quality ServerData Quality Server from command prompt, type the following command at the command prompt, and press ENTER:
dqsinstaller.exe -uninstall

解除安裝包含資料品質伺服器的 SQL Server 執行個體Uninstall SQL Server Instance Containing Data Quality Server

如果您要完整解除安裝內含 [SQL Server]SQL ServerData Quality ServerData Quality Server 執行個體,必須在完成解除安裝程序之後,手動刪除電腦中的 DQS_MAIN、DQS_PROJECTS 及 DQS_STAGING_DATA 資料庫。If you are completely uninstalling the [SQL Server]SQL Server instance that has Data Quality ServerData Quality Server, you must manually delete the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases from your computer after the uninstall process is complete. 針對預設的 [SQL Server]SQL Server 安裝,DQS_MAIN、DQS_PROJECTS 和 DQS_STAGING_DATA 資料庫檔案位於 C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA。For a default [SQL Server]SQL Server installation, the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases files are available at C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA.

另請參閱See Also

解除安裝現有的 SQL Server 執行個體 (Setup) Uninstall an Existing Instance of SQL Server (Setup)
解除安裝 SQL Server 2014Uninstall SQL Server 2014