SQL Generation

SQL generation uses the fetched and processed rows from the extraction and converts them into INSERT and UPDATE statements. The insert statements are done in order so that not null foreign keys are respected.

Not Null Columns

If an insert statement cannot be done without violating foreign key constraints due to nullable foreign keys, then it is split into an insert and update statement. If a nullable foreign key cannot be made null due to e.g. a CHECK constraint, then a simple rule can be added which tells the SQL generator to treat that column as if it were not null.

Examples:

Example	Description
Not Null Columns	Not Null Columns
Not Null Columns Switched	Not Null Columns Switched