9. Import and Export Tool Enhancements (Revision #36)

Enterprise environments demand importing and exporting data from hundreds of databases often with vastly different data format requirements. Getting data from one database vendor format, server and version to another is an around the clock necessity. The larger the amount of data transfered, the greater the need for import and export automation. Data imports and exports can get so large they overwhelm system resources if not properly managed and segmented, often requiring the entire process to be restarted. This version's Import and Export Tool Enhancements tackle these problems via new configurable transaction types, improved IO performance and one-click options for AquaScript Generation.

What's New for the Import Tool?

Import Tool Transaction Types	Export Tool Export Tables to Files in a Folder

Configurable Transaction Types

The Import Tool now provides configurable transaction types to optimize import performance and to throttle load to the database server.  There are 3 transaction modes available.

• Full - the method used by Aqua Data Studio 9.0 with one transaction per row.
• Batch - for choosing the number of rows to import in a single transaction.
• Threshhold - for setting a commit to the database every desired number of seconds.

Import IO Performance

Improved read IO performance with buffered reads to speed imports and assist with transaction speed.

Generate AquaScript

A button has been added to automatically generate an AquaScript which performs an import with the options chosen in the User Interface.  The AquaScript can be saved and executed at a later date or scheduled for execution in Aqua Data Server.

What's New for the Export Tool?

Export Tables to Individual Files

Export now allows exporting multiple tables at once into a folder, each table becoming a file within that folder.

  Export IO Performance

Export now has improved write IO performance with buffered writes to assist with database transactions and increasing export speed.

  Generate AquaScript

A button has been added to automatically generate an AquaScript which performs an export with the options chosen in the User Interface.  The AquaScript can be saved and executed at a later date or scheduled for execution in Aqua Data Server.