Table dependencies processing

CDBS products use unique algorithm analyzing tables dependencies when performing data synchronization and migration tasks.

View dependencies

The Foreign Keys/Dependencies tab displays list of foreign keys applied to a selected table and graphic dependencies diagram:

other schema's tables depending on the selected table
dependencies of the selected table on other schema's tables

Delete All Records

When deleting all data records from all the tables of a schema the program automatically sorts the processed tables depending on their relation with other schema's tables.

Drop All Tables

When deleting all the tables the program automatically sorts the tables depending on their relations with other schema's tables.

Batch Migration

When migrating table structures, the program automatically sorts the tables on basis of analysis of the relations between source schema's tables.

When migrating data of tables, the program automatically sorts the tables on basis of analysis of relations between target schema's tables.

User can change the order of the tables migration at his own discretion. At any stage of the migration configuring, user can instruct the program to rearrange the table list in accordance to their relations on side of target database by pressing on Sort by dependencies button.

Batch Synchronization

When synchronizing tables data, the program automatically sorts the tables on basis of analysis of relations between target schema's tables.

User can change the order of the tables synchronization at his own discretion.

At any stage of the synchronization configuring, user can instruct the program to rearrange the table list in accordance to their relations on side of target database by pressing on Sort by dependencies button.