add generate migrations automation commands/options in SCA VS plugin
when working on a VS project that includes a SCA project it would be useful to allow the developer to "automate" the capturing of changes in their development database (e.g. connection string that is defined in the sqlproj.user file) through some form of automation either as:
- part of a local build step (for example where a EF Core project has created and applied database a migration to a development database) that automatically generates and adds the new migration script to the SCA project; or
- is triggered as part of a git pre-check-in command (e.g. SCA PowerShell?)
It would be even better if the automated steps could then be used to trigger various other features that occur during the current manual SCA VS plugin process described here https://documentation.red-gate.com/sca/developing-databases/working-with-the-visual-studio-extension/generating-migrations-in-visual-studio
For example the "what has changed" view - as a sanity check to make sure the change made was what was expected by the developer.
This would be in an effort to reduce the number of manual steps required by a developer to enable a project to use varying complementary technologies (e.g. EF Core code-first for build and RedGate SCA for deployment).