# Source SQL Server Dump. Obviously compulsory
sql server dump filename=/tmp/dump

# These are used to generate SQL scripts (this is the only thing that is always done)
before file=/tmp/before
after file=/tmp/after
unsure file=/tmp/unsure

kettle directory=/tmp/kettle # Comment this line if you don't want a kettle script to be generated
# These are ignored as long as kettle is not set
sql server database=foo
sql server host=foo_host
sql server host instance=my_instance # You can omit this if you use the default instance
sql server port=1433
sql server username=foo_user
sql server password=foo_password
postgresql database=bar
postgresql host=bar_host
postgresql port=5432
postgresql username=bar_user
postgresql password=bar_password
parallelism_in=8 # Parallelism reading from SQL Server (where available) Default value is 1
parallelism_out=8 # Default value is 8. Number of parallel connections used by kettle to insert data into the PostgreSQL database

# Optional behaviour
case insensitive=0 # set it to 1 to generate a dump with citext and check constraints all over the place
no relabel dbo=1 # set it to 0 to convert the dbo schema to public
convert numeric to int=1 # set it to 0 to keep numeric(xx,0) as numeric(xx,0). Will be converted to smallint, int or bigint by default
relabel schemas=dbo=>foo;schema1=>bar
keep identifier case=1 # keep case of database objects
validate constraints = yes # yes, after or no, should the constraints be validated by the dump ? (yes=validate during load, after after the load, no keep invalidated)

# Incremental job
sort size=10000 # drives the amount of memory and temporary files that will be created by an incremental job
use pk if possible=0 # 1/list of tables, for tables where you want to try getting already sorted records

# Ignore errors ? (will be slower, and you'll have to read the migration job's log throroughly). Ignored for incremental jobs
ignore errors=0