Omni Loader documentation

Databases

Timeout in seconds

As we typically work with very large databases, it can take a while to process a command we send to the database. A value of zero means we will wait as long as it takes for the command to be processed. You can change the timeout if that's not what you need.

Column nullability

Whether source table column allows null values or not, we will replicate that settings, except in certain rare cases (such as if your source database allows null values in a primary key). You can override this setting and force all target columns to be nullable or not.

Incrementing values

You can disable identity/autoincrement fields being created if you wish.

Default values

You can disable table column default value when creating target tables, for all tables.