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.

Table indexing

• Primary Key ‍The primary key indexing option ensures that each row in the table is unique and not null, optimizing data retrieval based on the primary key column.

• Clustered Columnstore Index ‍This option creates a clustered columnstore index, which is ideal for high compression and performance on large datasets, particularly in data warehousing scenarios where query performance is critical.

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.