This post provides information about the Data Quality Services (DQS) improvements in the SQL Server 2012 Service Pack 1 (SP1) release, and step-by-step instructions to upgrade your current installation of DQS to the SP1 release. The steps to upgrade from the SQL Server 2012 RTM or any of the cumulative update (CU) releases to the SP1 release are the same.

List of DQS bugs fixed in the SQL Server 2012 SP1 release

For detailed information about the DQS bugs fixed in the SP1 release, see the article athttp://support.microsoft.com/kb/2674319, and search for "DQS" or "data quality".

Before You Upgrade

Upgrading DQS to the SP1 release involves upgrading the schema of DQS databases as well. Ensure that you back up your DQS databases before you upgrade to the SP1 release. Although, the DQS installer reminds you about backing up your databases during the process, it does not back up the databases as part of the process. You can manually perform a full backup of your DQS databases by running the following example script in SQL Server Management Studio:
USE MASTER;
GO
BACKUP DATABASE DQS_MAIN TO DISK='C:\mybackups\DQS_Main_fullbackup.bak';
BACKUP DATABASE DQS_PROJECTS TO DISK='C:\mybackups\DQS_Projects_fullbackup.bak';
BACKUP DATABASE DQS_STAGING_DATA TO DISK='C:\mybackups\DQS_Staging_fullbackup.bak';
GO
For more information about backing up and restoring DQS databases, see http://msdn.microsoft.com/en-us/library/hh213068(SQL.110).aspx.

How To Upgrade

  1. Download the appropriate SQL Server 2012 SP1 installer file (32-bit or 64-bit) from http://www.microsoft.com/en-us/download/details.aspx?id=35575.