FastTransfer Command Line Wizard

Set parameters and collect the built command line at the bottom of the page

Platform:

Source Configuration

Short Description	Value	Parameter	Default
Source Conn. Type		--sourceconnectiontype	[none]
Source Connect String		--sourceconnectstring	[none]
ODBC DSN		--sourcedsn	[none]
OleDB Provider		--sourceprovider	[none]
Source Server		--sourceserver	[none]
Source Trusted Auth?		--sourcetrusted	false
Source User		--sourceuser	[none]
Source Password		--sourcepassword	[none]
Source Database		--sourcedatabase	[none]

Source Query / Table

Short Description	Value	Parameter	Default
Source Schema		--sourceschema	[none]
Source Table		--sourcetable	[none]
SQL Query		--query	[none]
File Input		--fileinput	[none]

Target Configuration

Short Description	Value	Parameter	Default
Target Conn. Type		--targetconnectiontype	[none]
Target Connect String		--targetconnectstring	[none]
Target Server		--targetserver	[none]
Target Trusted Auth?		--targettrusted	false
Target User		--targetuser	[none]
Target Password		--targetpassword	[none]
Target Database		--targetdatabase	[none]
Target Schema		--targetschema	[none]
Target Table		--targettable	[none]

Advanced / Parallel

Short Description	Value	Parameter	Default
Parallel Degree		--degree	-2
Parallel method for parallelization		--method	None
Distribute Key Column		--distributekeycolumn	[none]
DataDriven Query (optionnal)		--datadrivenquery	[none]
Load Mode		--loadmode	Append
Column Map Method		--mapmethod	Position
Batch Size		--batchsize	1048576
Use Work Tables?		--useworktables	false

Logging

Short Description	Value	Parameter	Default
Run ID		--runid	[none]
Settings File		--settingsfile	[none]
Log Level		--loglevel	information

License

Short Description	Value	Parameter	Default
License		--license	[none] if not provided, will use FastTransfer.lic