22     Data Package  Export/Import

BI Studio provides a powerful export and import feature to export and import your data without any encoding, corruption and size problem. It also provides the advantage of blob data type export and import. You can backup your database data, transfer your data via internet or network or send it to your friends via e-Mail without any data corruption or data error.


Data Package  feature has .datapac  or .dpack file extension and can be opened by any zip utility. Data Package  feature allows you to export large databases that contains images or any blob data. it also allows you to protected the data package with a password. Data Package  file formatuses the ZIP file format to package data and it is also readable by and useful for third party applications.


Why should I use Data Package  Export/Import?

Exporting data as an SQL script is not suitable for large data or blob types. The data can corrupt or importing large SQL files can fail. Data Package  feature allows you to export and import your data in a secure way and by doing so you can share your data with third party applications.


22.1    Exporting Data Package

To export a Data Package you should select a database and its tables to export. The following dialog shows how to export a data package:


image Data Package  Data Package Export Dialog



22.2    Importing Data Package

The data packages can be imported from the same or different databases. To import a data package, you should first browse the package and assign the source-target tables. They will be automatically assigned when you browse the package.   If the data package encrypted with a password, you need to enter the password first then browse the package file.


Why should I assign the source/target tables?

Data Package  import feature allows you to import data from different tables. This means that the target and source table names must not be the same but their table structures must be the same, otherwise data will not be imported.



Data Package  Data Package Import Dialog


Assigning Target and Source Tables 

This list is used to import data between values in the source tables and the relevant tables in the target database. To assign a source table to a target table, select a value from the source table list on the left and the relevant target table from the list on the right and click the Assign Selected Tables button. To remove a relation, select an item from the right list and click the Remove button.



powered by Nucleon Software