SQL command

Symbol

An SQL command to be executed on the source or target database can be specified with this.

For example, the command DELETE * FROM <Table> can be used to delete a target table from the source table before it is transferred.

UPDATE commands can also be used. In this way, for example, you can execute a particular command on the database at regular timed intervals.

'Input help' area

Source alias

This is the database alias for the data source specified in the main node (transfer).

Changes made here will be reflected in the Transfer main node.

Target alias

The database alias in the main node (Transfer) for the target is shown here.

Changes made here will be reflected in the Transfer main node.

SQL command

The actual SQL command is entered here.

Complex commands must be split into consecutive transfer SQL command functions. Consecutive SQL commands cannot be processed in the SQL field.