Edit

Export a Knowledge Base to a .dqs File

  • Article

Applies to: SQL Server

This topic describes how to export an entire knowledge base to a .dqs data file in Data Quality Services (DQS). You can export a domain or an entire knowledge base to a data file. For information about exporting a domain, see Export a Domain to a .dqs File.

Exporting a knowledge base to a .dqs file, and then importing it as another knowledge base simplifies the knowledge generation process, saving time and effort. It enables you to share a knowledge base and its knowledge with others. The .dqs file will contain all knowledge base information, including domains and the matching policy, except for the attached reference data information. You must attach the required domains to appropriate reference data services again, if required, after importing the .dqs file. Both published and unpublished data in a knowledge base is exported.

The .dqs data file created by the export process is encrypted, so the contents cannot be viewed.

Before You Begin

Prerequisites

To export a knowledge base to a .dqs data file, you must have created and opened a knowledge base. You do not need to have a .dqs file to export into; one will be created for you.

Security

Permissions

You must have the dqs_kb_editor or the dqs_administrator role on the DQS_MAIN database to export a knowledge base to a .dqs data file.

Export a knowledge base to a .dqs file

  1. Start Data Quality Client. For information about doing so, see Run the Data Quality Client Application.

  2. In the Data Quality Client home screen, open a knowledge base in the Domain Management activity.

  3. In the Domain Management page (with any tab selected), click the Export Knowledge Base data icon above the Domain list, and then click Export Knowledge Base. Alternatively, you can also right-click in the Domain list, hover over Export, and then click Export Knowledge Base.

  4. In the Export to Data File dialog box, move to the folder that you want to save the file in, name the file or keep the knowledge base name, keep DQS Data Files (*.dqs) as the Save as type, and then click Save.

  5. In the Export Knowledge Base dialog box, verify that the status line indicates that the export completed. Click OK.

Follow Up: After Exporting a Domain to a .dqs File

After you export a knowledge base to a .dqs file, you can import the knowledge base into the same Data Quality Server (with a new name) or into a different Data Quality Server.