This article contains instructions to upgrade your Data Quality Services (DQS) installation from SQL Server 2012 RC0 to RTM release.

 Note
This upgrade preserves all of your DQS data (knowledge bases and projects), and you do not have to back it up before upgrading DQS.

Upgrade Data Quality Server

To upgrade the Data Quality Server component in DQS:

  1. Run the SQL Server 2012 RTM setup, and upgrade your SQL Server 2012 RC0 installation to the RTM release. For instructions about upgrading SQL Server, see Upgrade to SQL Server 2012 using the Installation Wizard (Setup).
  2. Start SQL Server Management Studio, connect to your SQL Server instance that you just upgraded, and run the following SQL statements:
    USE [DQS_MAIN]
    GO
    ALTER TABLE dbo.A_KNOWLEDGEBASE ADD [ORIGIN_KNOWLEDGEBASE_PUBLISH_DATE] [datetime] NULL;
    GO
    UPDATE dbo.A_KNOWLEDGEBASE SET ORIGIN_KNOWLEDGEBASE_PUBLISH_DATE=GETDATE() where ORIGIN_KNOWLEDGEBASE_PUBLISH_DATE is null;
    GO
  3. Next, run the command prompt. At the command prompt, change your directory to the location where DQSInstaller.exe is available. The DQSInstaller.exe file will be typically available at C:\Program Files\Microsoft SQL Server\MSSQL11.<InstanceName>\MSSQL\Binn. To change your directory:
    cd C:\Program Files\Microsoft SQL Server\MSSQL11.<InstanceName>\MSSQL\Binn
  4. Run the following command at the command prompt:
    dqsinstaller.exe -upgradedlls –instance <InstanceName>
Return to Top

Upgrade Client Components: Data Quality Client and DQS Cleansing Component in Integration Services

To upgrade Data Quality Client and the Data Cleansing component in Integration Services, run the SQL Server 2012 RTM setup, and upgrade your RC0 installation of Data Quality Client and Integration Services to the RTM release. For instructions about upgrading SQL Server, see Upgrade to SQL Server 2012 using the Installation Wizard (Setup).

Return to Top

Upgrade Master Data Services Add-in for Excel

To upgrade the Master Data Services Add-in for Excel, run the SQL Server 2012 RTM setup, and upgrade your RC0 installation of Master Data Services to the RTM release. For instructions about upgrading SQL Server, see Upgrade to SQL Server 2012 using the Installation Wizard (Setup). Next, download and install the Master Data Services Add-in for Excel for the SQL Server 2012 RTM release from here.

Return to Top

See Also