I learned to always have one database with every custom schema change in, and run my database unit tests (tSQLt is my favourite) on that one database.