Exporting Data to Another Data Source

Three types of export options exist for exporting data to another data source:

Connected: users have access to both source and target databases at the time of export. Records are inserted in the target database as they are read from the source. No data is stored locally.

Disconnected: the source and target databases are not connected at the time of export. This feature uses “DataBags” to store both the data and database schema in a file which can then be imported into another database. The DataBag functionality is superior to the typical export to a text file in that data size is not limited and binary and unprintable characters (such as tabs) correctly interpreted and exported.

Text file: data is exported from the source database to a text file and visa-versa