6. Import and Export Tool Enhancements (Revision #17)

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

• 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 now has improved read IO performance with buffered reads.
* Import Tool now has a "Generate AquaScript" button 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.

Export: Export now allows exporting multiple tables at once into a folder, each table becoming a file within that folder. Data is now buffered during export to assist with database transactions and increasing export speed.

* Export now has improved write IO performance with buffered writes.
* Export Tool now has a "Generate AquaScript" button 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.