Data Destination - SQL Server
  • 07 Dec 2022
  • PDF

Data Destination - SQL Server

  • PDF

Article summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

This page is a help page for setting up data transfer to SQLServer.

Supported Protocols

constraint

  • Nothing in particular

Setting items

STEP1 Basic settings

Itemnamerequireddefault
valuecontent
SQL Server connection informationYes-From the connection information registered in advance, select the one that has the necessary permissions for this transfer setting.
Database nameYes-Specify the name of the database to which you want to transfer.
schemaNo-Specify the destination schema name.
tableYes-Specify the name of the destination table
Custom variables can also be used to dynamically determine the setting value during trocco data transfer.
Transfer ModeYesinsertSelect the appropriate transfer mode: insert, insert_direct, truncate_insert, replace, or merge.
For details on modes, please refer to About Transfer Modes below.
Merge KeyNo-When the transfer mode is merge and the primary key does not exist in the destination table, specify the key column name of the data to be transferred.

About Transfer Modes

Mode NameContent
insertFirst, create an intermediate table and transfer the data. Once all intermediate tables have been created, insert data into the target tables.
If the target table does not exist, it is created automatically.
insert_directInserts rows directly into the target table.
If the target table does not exist, it is created automatically.
However, when the transfer fails, data may have been inserted into the target table.
truncate_insertIn insert mode, all contents of the target table are deleted before data is inserted into the target table.
replaceFirst, create an intermediate table and transfer the data. When the intermediate table creation is complete, delete the target table and change the intermediate table to the target table name.
However, if the transfer fails, the target table may be dropped.
mergeFirst, create an intermediate table and transfer the data. Once all intermediate tables have been created, the merge key for the intermediate table data will be updated if it already exists in the target table, otherwise the insert will be processed.
If the target table does not exist, it is created automatically.

STEP2 Advanced settings

Item namedefaultvalue content
Maximum number of retries12You can specify the maximum number of retries.
Retry latency (ms)1000You can specify the amount of time to wait when retrying.
Maximum retry wait time (ms)1800000You can specify the maximum amount of time to wait during retry.
Batch16777216You can specify the batch size.
Default time zoneUTCYou can specify a default time zone.
Connection Timeout (seconds)300You can specify the timeout in seconds before the driver connects.
If it is set to 0, it will be 15 seconds, which is the default for SQL Server.
Socket Timeout (seconds)1800You can specify the timeout in seconds before the query runs.
If it is set to 0, there is no timeout.

Was this article helpful?