# 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

# 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

# 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