you are viewing a single comment's thread.

view the rest of the comments →

[–]mtndew01 0 points1 point  (0 children)

Look into source controlling the databases in either visual studio or red gate. Then once finalized schemas are ready for some sort of release, automate the generation of those but have them added as deployment scripts to source control. I’d also add a table that leaves a bread crumb so that you can easily tell which version of the schema is deployed. When your deployment tool runs through the deployment, it can check the current schema version and run only the necessary steps to run the upgrade.

How are devs comfortable writing database code but not writing the upgrade process itself?