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"
Build your command with the Wizard