Import a Domain from a .dqs File
Applies To: SQL Server 2016
This topic describes how to import a domain from a .dqs file into an existing knowledge base in Data Quality Services (DQS). A .dqs data file is created by exporting a domain or knowledge base from the Data Quality Client application. A .dqs data file is encrypted, so cannot be viewed.
Using a .dqs data file to export a domain from one knowledge base and then import it to another knowledge base simplifies the knowledge generation process, saving time and effort. It enables you to share a domain and its knowledge with others, saving them time. You can import either one single domain or one composite domain (containing multiple single domains). A .dqs file containing a single domain includes all domain data including domain properties, values, and rules data, except for the mapped reference data information. A .dqs file containing a composite domain includes all composite domain data, including all domain data for the singles domains that are contained within the composite domain, and the composite domain properties, value relations, and CD rules, except for the mapped reference data. Published and unpublished data will be imported.
When you import a domain, the name of the domain remains the same as the name of the domain that was originally exported, unless the domain name already exists, in which case DQS will append “_1” to the name. This is also true if you import a composite domain that contains an individual domain with the same name as an existing domain.
To import a domain from a .dqs file, you must have already exported one single domain or one composite domain (containing multiple single domains) into the .dqs file. The .dqs file must only contain one domain. You must also have created and opened a knowledge base to import the domain into.
You must have the dqs_kb_editor or the dqs_administrator role on the DQS_MAIN database to import a domain from a .dqs data file.
Start Data Quality Client. For information about doing so, see Run the Data Quality Client Application.
In the Data Quality Client home screen, open a knowledge base in the Domain Management activity.
Click the Import Domain from data file icon.
In the Import from Data File dialog box, move to the folder that you want to import the file from, select the file (of type DQS File), and then click Open.
In the Import Domain dialog box, click OK.
The import operation will succeed only if the .dqs file that you are importing from contains only one single domain or one composite domain (containing multiple single domains).
Verify that the domain that you imported is displayed in the Domain list. If you imported a composite domain, verify that the composite domain and the single domains contained in it are all in the Domain list.
After you import a domain from a .dqs file, you can add knowledge to the domain or use the domain in a cleansing or matching project, depending on the contents of the domain. For more information, see Perform Knowledge Discovery, Managing a Domain, Managing a Composite Domain, Create a Matching Policy, Data Cleansing, or Data Matching.