Skip to main content
Version: 1.0 (Latest)

Target Connection Parameters

FastTransfer requires connection information to access your target database where data will be transferred. This page covers all target connection-related parameters.

Target Connection Type​

Specify the type of target database connection driver to use. This parameter determines how FastTransfer connects to your target database.

./FastTransfer \
...
--targetconnectiontype msbulk \
...
--targetconnectiontype

--targetconnectiontype "connection_type"

Available Connection Types, grouped by database. The types marked ADBC use the Arpe.io ADBC drivers (bundled; Windows x64 and Linux x64): see ADBC Connections.

SQL Server
  • msbulkSQL Server BulkCopy
  • adbc_mssqlADBCSQL Server (ADBC)
PostgreSQL
  • pgcopyPostgreSQL using COPY (binary format when the source connection type is also pgcopy, text format otherwise)
  • pgsqlPostgreSQL Native (.Net)
  • adbc_pgsqlADBCPostgreSQL (ADBC)
Oracle
  • orabulkOracle BulkCopy
  • oradirectOracle Direct
  • adbc_oracleADBCOracle (ADBC)
Teradata
  • teradataTeradata (.Net)
  • adbc_teradataADBCTeradata (ADBC)
IBM Netezza
  • nzbulkNetezza BulkCopy
  • adbc_netezzaADBCNetezza (ADBC)
IBM Db2
  • adbc_db2: Db2 for LUW (ADBC)
DuckDB
  • duckdbDuckDB
MySQL
  • mysqlbulkMySQL BulkCopy
SAP HANA
  • hanabulkSAP HANA
ClickHouse
  • clickhousebulkClickHouse BulkCopy
note

An adbc_* target needs an adbc_* source. See ADBC Connections.

Target Server​

Except if you have defined a target connection string, you must define a target server (or could also be a TNS entry for Oracle).

--targetserver

--targetserver "server"

Target Server Format Examples​

The target server parameter accepts different formats depending on your database:

IP address or DNS name
mytargetserver.mydomain.comHost
IP address or DNS name with port number
mytargetserver.mydomain.comHost: or ,1433Port
IP address or DNS name with named instance (SQL Server)
mytargetserver.mydomain.comHost\TARGETINSTANCENamed instance
Oracle: Easy Connect string
mytargetserver.mydomain.comHost:1521Port/TARGETPDBService
DuckDB: local file path
/path/to/target.duckdbDatabase file
The same formats in a command

IP address or DNS name:

./FastTransfer \
...
--targetserver "mytargetserver.mydomain.com" \
...

IP address or DNS name with port number:

./FastTransfer \
...
--targetserver "mytargetserver.mydomain.com:3306" \
...

or

./FastTransfer \
...
--targetserver "mytargetserver.mydomain.com,1433" \
...

IP address or DNS name with named instance (SQL Server):

./FastTransfer \
...
--targetserver "mytargetserver.mydomain.com\TARGETINSTANCE" \
...

For Oracle - Easy Connect string:

./FastTransfer \
...
--targetserver "mytargetserver.mydomain.com:1521/TARGETPDB" \
...

For DuckDB - Local file path:

./FastTransfer \
...
--targetconnectiontype duckdb \
--targetserver "/path/to/target.duckdb" \
...

Target Connection String​

Advanced Connection Options

You can use a connection string to define the connection to the target database. This connection string will override any other target connection parameters and can be used if the standard authentication modes are not sufficient for your use case.

You can use the target connection string for any connection type. The connection string must be enclosed in double quotes.

./FastTransfer \
...
--targetconnectstring "Server=mytargetserver;Database=mytargetdb;User ID=TargetUser;Password=TargetPassword;Encrypt=True;TrustServerCertificate=True"
...
--targetconnectstring

--targetconnectstring "connection_string"

Password Security in Logs

All passwords within the --targetconnectstring parameter are automatically hidden in all logs (Console, Files, and Database).

Target Database​

Define the target database name.

Example:

./FastTransfer \
...
--targetdatabase "AdventureWorks" \
...
--targetdatabase

--targetdatabase "database_name"

Matching Schema Requirements

The target table must already exist with a compatible schema. FastTransfer does not automatically create target tables. Ensure column data types are compatible between source and target databases.

Related
Copyright © 2026 Architecture & Performance.