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

• 
  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
  

  Peter_Laws February 14, 2023 11:20

  - 0 +
• 
  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.

  qs_007 February 14, 2023 14:25

  - 0 +
• 
  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.

  Peter_Laws February 16, 2023 13:45

  - 0 +

Add comment

Please sign in to leave a comment.