Settings and activity
3 results found
-
94 votes
As we noted in https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/2299881-migrations-support-for-git-mercurial, we have stopped work on Migrations v2 beta.
Unfortunately, there are currently no plans to include migration script rollbacks alongside the forward migration scripts, but we are still watching this request with interest.
-
1 vote
An error occurred while saving the comment -
1 vote
An error occurred while saving the comment Ruchika commentedHi Wesley,
Thanks for your feedback! There isn't a plan to work on Migrations v1 going forward. Instead, we're working on a new approach to solve migrations that would involve running all the migration scripts upfront. The reason for working on Migrations v2 is that we want to extend migration support for Git, Mercurial and other Distributed Version Control Systems. Migrations v2 will also support Azure databases, and will integrate well with CI systems for automated deployment. The beta is available for download here: http://documentation.red-gate.com/display/MV2
You're welcome to join our development discussions if you're further interested: https://groups.google.com/forum/#!forum/red-gate-migrations
Let me know if this has raised more questions than answered :- )
Thanks,
Ruchika
Hi Mark,
Thanks for sharing this idea with us. The team has already started some work on a different approach to solve Migrations that doesn’t require version control information. An early access release of SQL Source Control with this new functionality is available to download here: http://documentation.red-gate.com/display/MV2
Our approach is not quite the way you’ve explained above, but you should be able to handle the ‘adding a new column without a default’ scenario to handle existing data without having to check-in all the changes. The gist of Migrations v2 is that all the migration scripts will be run upfront during deployment. There are quite a few articles explaining this and a fair amount of discussion already going on in our Steering group. You’re welcome to join our discussions here: https://groups.google.com/group/red-gate-migrations
I hope this helps.
Regards,
Ruchika Raj
SQL Source Control Development Team