I'm interested in using a product that allows me to specify a target schema (and minimum data requirements) as part of an installation.
At install time, if the database doesn't exist, it is created. I have figured out how redgate takes us that far.
BUT, If the database ALREADY exists, I'd like the installer to create a custom change script right then, specific to that existing database, for the changes necessary to ensure that the target schema is as it ought to be.
The installer should attempt to build the change script, show any warnings of incompatible constraints, data loss, etc.
As a bonus, the installer might be tolerant of additional schema objects present in the existing database and leave them be (optionally), as long as the objects don't conflict with the target schema and minimum data.
SQL Packager seems to have all of the necessary technology to do this, but I haven't found it as an option.
Is it possible with redgate tools? Is there a very good technical reason why it can't/shouldn't be done this way?