3 ms·
For scripting database changes so they are deployed with app changes... or so they are automated and auto-tested upon deployment and in version control, I've ha
by gregw2 8y ago
For scripting database changes so they are deployed with app changes... or so they are automated and auto-tested upon deployment and in version control, I've had good success with open source Liquibase. Worth looking at Flyway also.
- clemson20 8y agoFor those using Microsoft SQL Server, we've had success using SQL Server Data Tools (SSDT), to automate database deployments for a few years now. Prior to this, developers would check-in 'delta scripts' - which were just all the sql changes that were manually applied. Now, the entire schema for multiple products is stored in source control as the source of truth, and deployments themselves generate and apply the deltas.