Skip to main content
Version: 1.0 (Latest)

ADBC

Examples with the adbc_* connection types, new in FastTransfer 1.0. Both ends use ADBC, and the target table must exist. See ADBC Connections for the rules.

PostgreSQL to SQL Server​

Parallel transfer with the Physical method (ctid on PostgreSQL), integrated authentication on the target.

.\FastTransfer.exe `
--sourceconnectiontype "adbc_pgsql" `
--sourceserver "pgserver:5432" `
--sourcedatabase "tpch" `
--sourceuser "FastUser" `
--sourcepassword "FastPassword" `
--sourceschema "tpch_10" `
--sourcetable "orders" `
--targetconnectiontype "adbc_mssql" `
--targetserver "localhost" `
--targettrusted `
--targetdatabase "tpch" `
--targetschema "dbo" `
--targettable "orders" `
--parallelmethod "Physical" `
--degree 8 `
--loadmode "Truncate"

Oracle to PostgreSQL​

Parallel transfer with the RangeId method on the order key. The Oracle table name is in upper case, as stored.

.\FastTransfer.exe `
--sourceconnectiontype "adbc_oracle" `
--sourceserver "oraserver:1521/ORCLPDB1" `
--sourceuser "TPCH" `
--sourcepassword "FastPassword" `
--sourceschema "TPCH" `
--sourcetable "ORDERS" `
--targetconnectiontype "adbc_pgsql" `
--targetserver "pgserver:5432" `
--targetdatabase "tpch" `
--targetuser "FastUser" `
--targetpassword "FastPassword" `
--targetschema "public" `
--targettable "orders" `
--parallelmethod "RangeId" `
--distributekeycolumn "O_ORDERKEY" `
--degree 8 `
--loadmode "Truncate"

Db2 to SQL Server​

Db2 for LUW is available as an ADBC source and target. Here a range-partitioned Db2 table is transferred with DBPartition: one stream per data partition.

.\FastTransfer.exe `
--sourceconnectiontype "adbc_db2" `
--sourceserver "db2server:50000" `
--sourcedatabase "TPCH" `
--sourceuser "db2inst1" `
--sourcepassword "FastPassword" `
--sourceschema "TPCH" `
--sourcetable "LINEITEM_PART" `
--targetconnectiontype "adbc_mssql" `
--targetserver "localhost" `
--targettrusted `
--targetdatabase "tpch" `
--targetschema "dbo" `
--targettable "lineitem" `
--parallelmethod "DBPartition" `
--degree 8 `
--loadmode "Truncate"

Teradata to SQL Server​

Parallel transfer with the Random method.

.\FastTransfer.exe `
--sourceconnectiontype "adbc_teradata" `
--sourceserver "tdserver" `
--sourcedatabase "TPCH" `
--sourceuser "dbc" `
--sourcepassword "FastPassword" `
--sourceschema "TPCH" `
--sourcetable "ORDERS" `
--targetconnectiontype "adbc_mssql" `
--targetserver "localhost" `
--targettrusted `
--targetdatabase "tpch" `
--targetschema "dbo" `
--targettable "orders" `
--parallelmethod "Random" `
--distributekeycolumn "O_ORDERKEY" `
--degree 4 `
--loadmode "Truncate"

SQL Server to Oracle with connection strings​

The connection strings use the drivers' uri= format. Special characters in a password must be percent-encoded (@ → %40).

.\FastTransfer.exe `
--sourceconnectiontype "adbc_mssql" `
--sourceconnectstring "uri=sqlserver://FastUser:FastPassword@sqlserver:1433/?database=tpch" `
--sourceschema "dbo" `
--sourcetable "orders" `
--targetconnectiontype "adbc_oracle" `
--targetconnectstring "uri=oracle://TPCH:FastPassword@oraserver:1521/ORCLPDB1" `
--targetschema "TPCH" `
--targettable "ORDERS" `
--parallelmethod "Physical" `
--degree 8 `
--loadmode "Truncate"

Linux​

The same commands work on Linux x64, with ./FastTransfer and \ as the line continuation:

./FastTransfer \
--sourceconnectiontype "adbc_pgsql" \
--sourceserver "pgserver:5432" \
--sourcedatabase "tpch" \
--sourceuser "FastUser" \
--sourcepassword "FastPassword" \
--sourceschema "tpch_10" \
--sourcetable "orders" \
--targetconnectiontype "adbc_pgsql" \
--targetserver "pgtarget:5432" \
--targetdatabase "tpch" \
--targetuser "FastUser" \
--targetpassword "FastPassword" \
--targetschema "public" \
--targettable "orders" \
--parallelmethod "Physical" \
--degree 8 \
--loadmode "Truncate"
tip

Build your command with the Wizard

Copyright © 2026 Architecture & Performance.