importing-and-exporting-knowledge.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
Importing and Exporting Knowledge	Importing and Exporting Knowledge	swinarko	sawinark	07/31/2012	sql	data-quality-services	conceptual

Importing and Exporting Knowledge

[!INCLUDE SQL Server - Windows only ASDBMI]

You can create knowledge bases and domains directly in the [!INCLUDEssDQSClient] application, or you can import knowledge into, or export it from, a knowledge base. In the [!INCLUDEssDQSClient] application, you can use a data file for import and export operations, or an Excel file for import operations. The data file used is an encrypted file that is created by [!INCLUDEssDQSnoversion] (DQS) with a .dqs extension. The files created by Microsoft Excel can have an extension of .xlsx, .xls, or .csv. These operations give you more flexibility in building and sharing the knowledge that you use to perform data cleansing and matching.

Important

You can export all the knowledge bases in your [!INCLUDEssDQSServer] to a DQS backup file (.dqsb) at once by running the DQSInstaller.exe file from the command prompt. Similarly, you can import all the knowledge bases from a DQS backup file (.dqsb) to your [!INCLUDEssDQSServer] at once by running the DQSInstaller.exe file from the command prompt. For information about doing so, see Export and Import DQS Knowledge Bases Using DQSInstaller.exe in the DQS installation guide.

In This Section

You can perform the following import and export operations:

Operation Description	Topic
Export a domain in a knowledge base to a .dqs data file	Export a Domain to a .dqs File
Import a domain from a .dqs data file into an existing knowledge base	Import a Domain from a .dqs File
Export an entire knowledge base to a .dqs data file	Export a Knowledge Base to a .dqs File
Import an entire knowledge base to a .dqs data file	Import a Knowledge Base from a .dqs File
Import values from an Excel file into a domain	Import Values from an Excel File into a Domain
Import domains from an Excel file into a knowledge base	Import Domains from an Excel File in Knowledge Discovery
Import knowledge gathered during cleansing into a knowledge base	Import Cleansing Project Values into a Domain

Related Tasks

Task Description	Topic
Building a knowledge base by running knowledge discovery and interactively managing knowledge	Building a Knowledge Base
Creating a single domain, and adding knowledge to the domain.	Managing a Domain
Creating a composite domain, and adding knowledge to the domain.	Managing a Composite Domain