|
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
|
|
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
|
|
Last reviewed on 14 June 2014
Copyright 2014 Cardett Associates Ltd. All rights reserved.
|