I would like that the generated scripts, when databases are in the same instance, can be optimized.

If I compare two tables based on their PK and then I want to insert all the "IDs" that do not exists, instead of having one INSERT INTO statement per record, we can could have:

INSERT INTO destination
SELECT <all columns>
FROM source
<WHERE ID IN/BETWEEN/= too if just specific records>

On cases where all records are new, this can make the script goes from multiple MB to a couple of KBs.

It will be faster to generate, easier for the GUI to open and deal with it.

Let me know if you need more info