3 ms·
We have a db schema update tool. We generate an XML file representing the schema which is committed to source control. Then when new version is being deployed,
by magicalhippo 6y ago
We have a db schema update tool. We generate an XML file representing the schema which is committed to source control.
Then when new version is being deployed, the tool compares the database with the XML, and generates SQL to alter the database.
For stored procs etc it compares the text of them, so those that weren't changed are ignored.
It's a simple homebrew tool but it gets the job done.