Add SSC database project
The SCA database project only supports the migration approach. I would like to have is support the SSC (state/model approach) style project. My Devs are far more comfortable using Visual Studio to interact with the DB than SSMS+SSC. As long as the correct script is in source control - I don't really care how it gets there and is updated (SSC or VS).
AdminKendra (Product Manager, Redgate) commented
Hi Paul, thanks for this suggestion.
We have recently added the ability for a "Hybrid" development model where a SQL Source Control project may now be considered the development "source" for a SQL Change Automation project.
An article on the hybrid model is here:
I believe that this meets the spirit of your request, so I'm going to mark this one completed. We very much welcome your further feedback on this and whether the hybrid model meets your needs, or if you have further ideas to refine it. We do have plans to iterate on this model further in 2021.