Embed Notice

I'll need to automate database deployment with my team on the next weeks so I'd like to chat about this subject with anyone with ideas, experience or content to share.

We already use db projects on visual studio and deploy the dacpac via sqlpackage. We will change it because:
1. db proj support only SQL Server and now we are also using postgres
2. the extended deploy window
3. the rollback strategy based on backup instead of scripts for simple cases

Instead of having a snapshot of the db schema and dynamically calculate the diff before deployment, I like the idea of having small deltas as liquibase seems to use. Taylor-made deltas would be nice also, but I need to find good tools to generate schema diffs.

Feel free to share your opinions, experiences or recommendations.