I'm trying to figure out the best way to do the following:

• Keep local dev databases synced with remote dev/uat databases
• Initialize database state (schema and golden data) for CI purposes

I've thought about using SSIS packages, or some elaborate PowerShell script, etc, and started spinning up a few POCs, but I know there are better solutions out there. We're thinking of using EF Migrations for schema, so data is my main concern, but I'd love to know about both.

Any suggestions?