Toad World® Forums

Set compare order for schema objects


#1

We want to compare and synchronize schema objects, and for the synch script we would like to be able to change the order of the objects (most probably in order to accommodate dependencies between tables). Obviously, you could do that manually in the editor, but that is cumbersome and error prone when dealing with large schemas.


#2

Hi, we would like to know why user needs this functionality (reorder statements in sync scripts).

Toad Edge Sync functionality is designed to generate sync script in order to reflect all dependencies in database, statements are not ordered just alphabetically.

When the sync script is not deployable, there is probably a bug.

br.
Miroslav Stanik