AQT v10 Load Multiple Tables

This feature allows you to load data into multiple tables in a single operation. This is invaluable when migrating tables between different schemas or databases, or resyncing two different environments.
  • built on top of the AQT Data Loader, which has proven to be one of the most powerful and flexible data loaders on the market
  • you can load your tables from other tables (in the same or another database), a directory of csv files, or worksheets of an Excel file
  • you can apply a filter to select which tables you wish to load
Load Data

A More Advanced Example

  • an example of loading tables from a directory of files
  • the Load is running in Create Table mode, so a table will be created for every file in the directory
  • AQT will do a pre-scan of the file to create the columns of the correct data types
  • the Match Tables specifies how the table name is to be composed from the file name
Load Tables
  Go Home Go to Top

Last reviewed on 14 June 2014   

Copyright 2014 Cardett Associates Ltd. All rights reserved.