Skip to content

Latest commit

 

History

History
57 lines (40 loc) · 5.75 KB

export-and-import-dqs-knowledge-bases-using-dqsinstaller-exe.md

File metadata and controls

57 lines (40 loc) · 5.75 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Export and import DQS knowledge bases using DQSInstaller.exe
Learn how to use the DQSInstaller.exe to export and import DQS Knowledge bases for SQL Server Data Quality Services (DQS).
swinarko
sawinark
03/01/2017
sql
data-quality-services
how-to

Export and Import DQS Knowledge Bases Using DQSInstaller.exe

[!INCLUDE sql-windows-only]

For an existing installation of DQS, you can export all the knowledge bases in your [!INCLUDEssDQSServer] to a DQS backup file (.dqsb) at once, and then later use the .dqsb file to import all the knowledge bases to a different [!INCLUDEssDQSServer] at once by running the DQSInstaller.exe file from the command prompt. For more information about running DQSInstaller.exe from the command prompt, see Run DQSInstaller.exe from Command Prompt in Run DQSInstaller.exe to Complete Data Quality Server Installation.

This feature enables you to take a backup of all your knowledge bases in [!INCLUDEssDQSServer] at once without having to individually export each knowledge base to a .dqs file by using [!INCLUDEssDQSClient]. Similarly, you can import all the knowledge bases from the backup file into another [!INCLUDEssDQSServer] at once without having to individually import each knowledge base from a .dqs file by using [!INCLUDEssDQSClient]. This is particularly useful for backing up and restoring your knowledge bases when you are uninstalling [!INCLUDEssDQSServer] on a computer, and then reinstalling it on a different computer. You can easily export all the knowledge bases in an existing installation of [!INCLUDEssDQSServer] to a DQS backup file (.dqsb), and then import all the knowledge bases from the backup file after installing [!INCLUDEssDQSServer] on a different computer.

Exporting Knowledge Bases to .dqsb File

You can export all the knowledge bases in the existing [!INCLUDEssDQSServer] at any time or while uninstalling [!INCLUDEssDQSServer].

  • To export all the knowledge bases in a [!INCLUDEssDQSServer] to a DQS backup file (.dqsb), run DQSInstaller.exe with the exportkbs parameter from the command prompt, along with the full path and file name where you want to export the knowledge bases. For example, to export all the knowledge bases to the DQSBackup.dqsb file in the C: drive:

    dqsinstaller.exe -exportkbs c:\DQSBackup.dqsb

    [!NOTE]
    If the provided file name already exists at the specified location, the installer prompts you whether to overwrite the file.

  • To export all the knowledge bases to a DQS backup file while uninstalling [!INCLUDEssDQSServer], run DQSInstaller.exe with the uninstall parameter from the command prompt, along with the full path and file name where you want to export the knowledge bases. For example, to export all the knowledge bases to the DQSBackup.dqsb file in the C: drive, and then uninstall [!INCLUDEssDQSServer]:

    dqsinstaller.exe -uninstall c:\DQSBackup.dqsb

    [!NOTE]
    If you do not specify the full path and file name of the DQS backup file while uninstalling [!INCLUDEssDQSServer] from the command prompt using the uninstall parameter, a message is displayed stating that all the knowledge bases will be deleted, and allows you to choose whether to continue with the uninstall process.

Importing Knowledge Bases from .dqsb File

You can import all the knowledge bases from a DQS backup file (.dqsb) after completing the [!INCLUDEssDQSServer] installation. To import knowledge bases, you must have a valid DQS backup file (.dqsb).

Run the DQSInstaller.exe file with the importkbs parameter from the command prompt, along with the full path and file name from where you want to import the knowledge bases. For example, to import all the knowledge bases from the DQSBackup.dqsb file in the C: drive:

dqsinstaller.exe -importkbs c:\DQSBackup.dqsb

If there are existing knowledge bases in your [!INCLUDEssDQSServer] with the same name as the ones you are importing, the names of the imported knowledge bases will be appended with an underscore (_) followed by an integer value starting with 1. For example, if the "CompanyName" domain is duplicate, the imported domain name will be "CompanyName_1."

See Also

Run DQSInstaller.exe to Complete Data Quality Server Installation
Install Data Quality Services
Export a Knowledge Base to a .dqs File
Import a Knowledge Base from a .dqs File