Migrations in SQL Source Control 5 no longer requires a separate repository, so you should now be able to use it with your setup.

If you don’t have the tool installed, you can download it from http://www.red-gate.com/products/sql-development/sql-source-control/.

If you already have SQL Source Control you can get the new version via Check for updates in the Help menu of SQL Source Control inside SSMS.

You can see other Migrations examples and tutorials here: https://documentation.red-gate.com/display/SOC5/Migration+script+examples

If you’ve stuck with us since 2011, many thanks. If not, maybe now is a good time to give the product another look? :-)

We’re currently working on v2 of Migrations, which no longer requires you to specify a separate migration location on the setup tab. An Early Access Release of SQL Source Control is now available with Migrations v2. To download, please see http://documentation.red-gate.com/display/MV2.

NOTE: This is an Early Access Release and is not fully tested or functionally complete yet. It would be great if you could try it in a test environment and let us know about your experiences so we can fix any issues and try to make any updates you need before the full release.

Thank you!
Stephanie Herr :-)
SQL Source Control Product Manager

For now you need to unlink and re-link repository using the “Unlink database…” link on the Setup Tab.

Keep voting here if you’d rather see some kind of edit capability.