Lets assume the following:
- 5 devs all working on laptops
- Each develops/debugs on Azure compute emulator (code) and SQL Server (db) - both running locally on their laptops.
I'd like to have
- These 5 SQL 'Servers' need to sync with each other
- BONUS: If the 5 SQL servers can also sync with (non-production) Azure SQL database!
How can I set this up? The way we're setup, all dev's eventually diverge from the 'reference' database (both schema and data) and pruning it is a PITA. I'm hoping there are some tools to alleviate this issue.