Source Connection Parameters
FastTransfer requires connection information to access your source database where data will be extracted. This page covers all source connection-related parameters.
Source Connection Type
Specify the type of source database connection driver to use. This parameter determines how FastTransfer connects to your source database.
./FastTransfer \
...
--sourceconnectiontype mssql \
...
--sourceconnectiontype--sourceconnectiontype "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.
mssqlSQL Server Native Client (.Net)msoledbsqlSQL Server OleDBadbc_mssqlADBCSQL Server (ADBC)
pgsqlPostgreSQL Native (.Net)pgcopyPostgreSQL Copyadbc_pgsqlADBCPostgreSQL (ADBC)
oraodpOracle ODP.Netadbc_oracleADBCOracle (ADBC)
teradataTeradata (.Net)adbc_teradataADBCTeradata (ADBC)
nzsqlNetezza Native (.net driver)nzoledbNetezza OleDBadbc_netezzaADBCNetezza (ADBC)
adbc_db2: Db2 for LUW (ADBC)
duckdbDuckDBduckdbstreamDuckDB using streaming (more memory efficient)
mysqlMySQL
hanaSAP HANA (.net driver)
clickhouseClickHouse
odbcODBC datasource (DSN must be configured)oledbGeneric OleDB datasource
An adbc_* source needs an adbc_* target. See ADBC Connections.
Source DSN (Data Source Name)
If you have chosen an ODBC connection type for the source, you must define the DSN with the --sourcedsn parameter, or alternatively define a connection string using --sourceconnectstring.
./FastTransfer \
...
--sourceconnectiontype odbc \
--sourcedsn "MySourceODBCDataSource" \
...
--sourcedsn--sourcedsn "DSN_name"
Source Provider
If you have chosen an OLEDB connection type for the source, you must define the OLEDB provider with the --sourceprovider parameter.
- SQL Server (MSOLEDBSQL)
- Netezza (NZOLEDB)
./FastTransfer \
...
--sourceconnectiontype oledb \
--sourceprovider MSOLEDBSQL \
...
./FastTransfer \
...
--sourceconnectiontype oledb \
--sourceprovider NZOLEDB \
...
--sourceprovider--sourceprovider "provider_name"
Source Server
Except if you have defined a source connection string, you must define a source server (or could also be a TNS entry for Oracle).
--sourceserver--sourceserver "server"
Source Server Format Examples
The source server parameter accepts different formats depending on your database:
mysourceserver.mydomain.comHostmysourceserver.mydomain.comHost: or ,2433Portmysourceserver.mydomain.comHost\myinstanceNamed instancemysourceserver.mydomain.comHost:1521Port/myinstanceInstanceMYTNSTNS entryThe same formats in a command
IP address or DNS name:
./FastTransfer \
...
--sourceserver "mysourceserver.mydomain.com" \
...
IP address or DNS name with port number:
./FastTransfer \
...
--sourceserver "mysourceserver.mydomain.com:2433" \
...
or
./FastTransfer \
...
--sourceserver "mysourceserver.mydomain.com,2433" \
...
IP address or DNS name with named instance:
./FastTransfer \
...
--sourceserver "mysourceserver.mydomain.com\myinstance" \
...
For Oracle - Easy Connect string:
./FastTransfer \
...
--sourceserver "mysourceserver.mydomain.com:1521/myinstance" \
...
For Oracle - TNS entry:
./FastTransfer \
...
--sourceserver "MYTNS" \
...
Source Connection String
You can use a connection string to define the connection to the source database. This connection string will override any other connection parameters and can be used if the other authentication modes are not enough for your case.
You can use the connection string for any source connection type. The connection string must be enclosed in double quotes.
Example:
./FastTransfer \
...
--sourceconnectstring "Server=myserver;Database=mydb;User ID=FastUser;Password=FastPassword;Encrypt=True;TrustServerCertificate=True"
...
--sourceconnectstring--sourceconnectstring "connection_string"
All passwords within the --sourceconnectstring parameter are automatically hidden in all logs (Console, Files, and Database).
Source Database
Define the source database name.
Example:
./FastTransfer \
...
--sourcedatabase "AdventureWorks" \
...
--sourcedatabase--sourcedatabase "database_name"
- Target Connection Parameterswhere the data goes
- Authenticationtrusted connection or SQL login
- ADBC Connectionsthe
adbc_*connection types