## Transfer Tool

### What is the Hypersonic Transfer Tool

The Hypersonic Transfer Tool is a Java application that can transfer data from any JDBC data source to another. It is currently mainly tested with Hypersonic SQL, but should work with every database as source and as target that support the JDBC interface. It is (as all other Java programs here) Open Source and free.

You can test the applet version of the Transfer Tool. It can be started from the Database Manager, Options / Transfer, but when the Database Manager is running as an Applet, you can't connect to other databases than the Hypersonic SQL In-Memory database.

### Steps

This are the steps of a data transfer using the Transfer Tool:

- Connect to source database
- Connect to target database
- Modify transfer options if necessary
- Start transfer

### Connect dialogs

The connection to the databases is simple: select the driver class name, the url, the user name and the password. The connection dialog for the target database looks the same.

### The main window

After the Transfer Tool is connected, the tables of the source database are read and listed on the left side. On the right side, it is possible to modify the transfer settings for each table. The progress / error message is shown on the bottom line.

### Modify transfer options

After selecting a table on the right side, the transfer options for this table can be changed:

- Transfer to destination table
  The transfer of this table can be switched on and off here. On the next line the destination table name can be modified.
- Drop destination table
  If the destination table already exists, it can be dropped using this switch. This step can be switched on and off, and additionally the DROP TABLE statement can be modified here. Errors of this step are ignored, so it is no problem if the table does not exist and is 'dropped' anyway.
- Create destination table
  If the table already exists, this step can be switched off. It is also possible to modify the CREATE TABLE statement here.
- Delete rows in destination table
  All rows of the destination table are removed first if this checkbox is switched on. If switched off, the records are appended.
- Select source records
  The SELECT statement can be modified where. It is possible to change the statment in any way, including any formulas and conditions that are supported by the source database. The order of columns must match the order columns in the INSERT statement.
- Insert into destination
  The insert can be switched on and off also. The insert is done using a Prepared Statement, this is why the values are listed as '?'.

### Options

By default all rows are transfered. But for a quick test if the transfer will work for all tables, the maximum count records can be set to 10 or 1000.

### Development / Download

All Java source code (including the database engine of course) of this program are Open Source. The Transfer Tool is included in the download. Transfer Tool is programmed using AWT.