Ever tried EntityFramework in .Net ? It's amazingly easy and there are 2 ways:
- Database-First
- Code-First
- Database-First
- Code-First
Create an SQL project that defines the schema. It automatically compares the schema with your current dB schema and auto generates a migration script for you.
Then update entities from the dB.
Few steps involved but avoids writing and maintaing migrations yourself.
I don't want to go back to any sort of migrations outside of this.