Generated migration script includes all of uncommited changes, ignored user selection

qs_007

Is this the expected behavior? version 6.0.0

Peter_Laws

Hi qs_007, 

Yes it is, please the default comparison settings below, users are ignored by default. Largely due to the expectation that you do not wish to graduate your dev users to prod.
https://documentation.red-gate.com/fd/sql-server-comparison-options-138347108.html

qs_007

Sorry, my question might be unclear. It is not about the user object, but flyway tool user's selection of uncommitted changed schemas, all of the uncommitted schemas were automatically made into the migration script, I cannot generate the migration script only including my selection of the uncommitted.

Peter_Laws

Oh I do apologies, I got completely the wrong end of the stick!

Please could you check if there are any dependencies between these objects?
Including dependencies is enabled by default which could be undermining your efforts.
https://documentation.red-gate.com/fd/sql-server-comparison-options-138347108.html

If that's not the origin then I'd be happy to raise a support ticket on this for you so we can work through it together.