We also used migration scripts in SQL Source Control without the need to use SQL Compare. Is this just a way to force us to purchase SQL Compare? With the new method, I'm still not sure how to create a simple migration script based on a changeset. In practice, we create migrations that are promoted from DEV to QA to STG to PRD. Environments other than DEV don't need to be in Source Control.
We also used migration scripts in SQL Source Control without the need to use SQL Compare. Is this just a way to force us to purchase SQL Compare? With the new method, I'm still not sure how to create a simple migration script based on a changeset. In practice, we create migrations that are promoted from DEV to QA to STG to PRD. Environments other than DEV don't need to be in Source Control.