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 mssql \
...

Syntax:

• Short form: -C "connection_type"
• Long form: --targetconnectiontype "connection_type"

Available Target Connection Types:

Connection Type	Description
clickhousebulk	ClickHouse BulkCopy
duckdb	DuckDB
hanabulk	SAP HANA
msbulk	SQL Server BulkCopy
mysqlbulk	MySQL BulkCopy
nzbulk	Netezza BulkCopy
orabulk	Oracle BulkCopy
oradirect	Oracle Direct
pgcopy	PostgreSQL using copy (Binary format for postgresql sources and Text for others)
pgsql	PostgreSQL Native (.Net)
teradata	Teradata (.Net)

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).

Syntax:

• Short form: -I "server"
• Long form: --targetserver "server"

Target Server Format Examples

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

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.

Example for SQL Server:

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

Example for PostgreSQL:

./FastTransfer \
...
 --targetconnectionstring "Host=mytargetserver;Database=mytargetdb;Username=TargetUser;Password=TargetPassword;SSL Mode=Require"
...

Syntax:

• Short form: -g "connection_string"
• Long form: --targetconnectionstring "connection_string"

Password Security in Logs

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

Target Database

Define the target database name.

Example:

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

Syntax:

• Short form: -D "database_name"
• Long form: --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.