安装 SQL Server 更新后升级 DQS 数据库架构Upgrade DQS databases schema after installing SQL Server update
03/01/2017
本文内容
适用于:Applies to:SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions)-仅限 Windows适用于:Applies to:
SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions) - Windows only
当你在先前配置的 DQS 实例上安装了 SQL Server 更新(补丁、修补程序或累积更新)后,你可能需要运行 DQSInstaller.exe 文件(带 upgrade 命令行参数)来升级 DQS 数据库架构。After you have installed a SQL Server update (patch, hotfix, or cumulative update) on a previously configured DQS instance, you might have to upgrade the DQS databases schema by running the DQSInstaller.exe file with the upgrade command line parameter. 否则,当您尝试使用数据质量客户端连接到数据质量服务器时,可能会收到以下错误:Otherwise, you might receive the following error while trying to connect to Data Quality Server using your Data Quality Client:
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65581.
升级 DQS 数据库架构不会影响 DQS 数据库(知识库、数据质量项目以及 DQS_STAGING_DATA 数据库中的已导出结果)中的现有数据。Upgrading DQS databases schema does not impact your existing data in the DQS databases (knowledge bases, data quality projects, and exported results in the DQS_STAGING_DATA database). 但是,您必须先备份 DQS 数据库,然后才能升级 DQS 数据库架构,以防止在架构升级过程中出现任何意外数据损失。However, you must back up your DQS databases before upgrading DQS databases schema to prevent any accidental data loss during the schema upgrade. For information about backing up DQS databases, see Backing Up and Restoring DQS Databases.
备注
大多数 SQL Server 更新将要求升级到 DQS 数据库架构。Most of the SQL Server updates will require an upgrade to the DQS databases schema. 有关要求升级到 DQS 数据库架构的 SQL Server 更新的信息,请参阅 升级 DQS:在 Data Quality Services 中安装累积更新或修补程序中的步骤 1.A。For information about the SQL Server updates that will require an upgrade to the DQS databases schema, see the chart in step 1.A in Upgrade DQS: Installing Cumulative Updates or Hotfix Patches on Data Quality Services.
先决条件Prerequisites
您必须作为 数据质量服务器Data Quality Server 计算机上 Administrators 组的成员登录。You must be logged on as a member of the Administrators group on the 数据质量服务器Data Quality Server computer.
您的 Windows 用户帐户必须是安装了 数据质量服务器Data 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 Server is installed.
升级 DQS 数据库架构To upgrade DQS databases schema
(建议)首先备份 DQS 数据库,然后进行架构升级。(Recommended) Back up your DQS databases before you proceed with the schema upgrade. For information about backing up DQS databases, see Backing Up and Restoring DQS Databases.
启动命令提示符。Start Command Prompt.
在命令提示符下,将目录更改为 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\MSSQL13.MSSQLSERVER\MSSQL\Binn 下:If you installed the default instance of SQL Server, the DQSInstaller.exe file will be available at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn:
cd C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn
在命令提示符下,键入以下命令,再按 Enter:At the command prompt, type the following command, and press ENTER:
dqsinstaller.exe -upgrade
安装程序会提示您在继续操作之前备份 DQS 数据库。The installer prompts you for backing up the DQS databases before proceeding. 如果已经备份了 DQS 数据库,请键入 Y 或 Yes ,然后按 Enter 以继续升级。If you have already backed up your DQS databases, type Y or Yes and press ENTER to continue with the upgrade.
在成功升级 DQS 数据库架构之后,将显示一条完成消息。A completion message is displayed after successful upgrade of the DQS databases schema.
后续步骤Next Steps
从数据质量客户端应用程序登录到升级后的数据质量服务器。Log on to the upgraded Data Quality Server from a Data Quality Client application.
有关安装 SQL Server 更新后升级 DQS 数据库架构以及相关故障排除步骤的详细信息,请参阅 升级 DQS:在 Data Quality Services 中安装累积更新或修补程序更新。For more information about upgrading DQS databases schema after installing SQL Server updates and associated troubleshooting steps, see Upgrade DQS: Installing Cumulative Updates or Hotfix Patches on Data Quality Services.
另请参阅See Also