User profile for Ruchika

Hi Joseph, Yes, there is a provision to add rollback scripts which will be applied whenever you're doing a rollback. Basically, every migration script in V2 consists of two parts - an upgrade script and a downgrade script. As of now the user interface only allows you to add an upgrade script, but the engine code handles downgrade scripts as well. Let's say you wanted to rollback your database from v3.0 to v2.0 (the previous version), the migration engine would then look for the migrations scripts that had been applied as part of the upgrade from v2.0 to v3.0. It would then pick the corresponding rollback scripts and apply them in order before the SQL Compare Engine rolls back the rest of the schema change. As an example, if you're doing a table rename in your migration script, you could include a rollback script that would do the reverse of the rename. Let me know if you need any help with adding the rollback scripts. Could you help clarify what you meant by whether this will break the existing rollback mechanism? The mechanism for SQL Compare rollback is still the same. The only difference here would be that the migration script rollbacks would be applied first. The TempDb setup is not mandatory. MigrationsV2 by default tries to connect to LocalDb if you have one installed. I think that would explain why this still worked for you. :-) Regarding your last point, we don't have an ETA yet, but we're working actively towards it. I'll keep you up-to-date on this. In one of your previous comments you mentioned that "A check-in a command line script will execute and update the changes to the 'Test database'" from the TestBranch. Is it fair to assume that you're using the SQL Compare command line to achieve this? Also, I'm very keen to know how your environment was setup when you evaluated the beta. Let us know if you have any other feedback from your evaluation experience. Thanks, Ruchika / comments

Hi Joseph, Yes, there is a provision to add rollback scripts which will be applied whenever you're doing a rollback. Basically, every migration script in V2 consists of two parts - an upgrade scrip...

0 votes

Hi Joseph, I've written a quick guide to help you with the command line tool: ftp://support.red-gate.com/patches/SQL_ ... e_tool.pdf Let me know if you still need any help. Cheers, Ruchika / comments

Hi Joseph, I've written a quick guide to help you with the command line tool:ftp://support.red-gate.com/patches/SQL_ ... e_tool.pdf Let me know if you still need any help. Cheers, Ruchika

0 votes

Hi Joseph, We're expecting to do a beta release of SQL Compare with Migrations V2 sometime during the 2nd week of October. Meanwhile, were you able to use the migs.exe command line to generate your deployment scripts? Cheers, Ruchika / comments

Hi Joseph, We're expecting to do a beta release of SQL Compare with Migrations V2 sometime during the 2nd week of October. Meanwhile, were you able to use the migs.exe command line to generate you...

0 votes

Hi Joseph, As Stephanie mentioned, you can now download the command line tool to use in your automated deployments from here: http://documentation.red-gate.com/display/MV2/ The above link also contains documentation to help you get started with migrations V2. If you want to be more involved in our development decisions, please join us at https://groups.google.com/group/red-gate-migrations Let me know if you need any help with the command line tool. Thanks, Ruchika Raj SQL Source Control Development Team Red Gate Software Ltd. T: 01223 438855 / comments

Hi Joseph, As Stephanie mentioned, you can now download the command line tool to use in your automated deployments from here: http://documentation.red-gate.com/display/MV2/ The above link also cont...

0 votes

Hi Brian/Mattias, It sounds like you're both using MigrationsV1: http://www.red-gate.com/supportcenter/c ... Migrations There is a new beta version of Migrations that the team is currently working on. See here: http://documentation.red-gate.com/display/MV2 I'd encourage you to try the beta version out as we've improved a lot of functionality in the beta and made it such that it can be better integrated with your CI system. Also, you should be able to handle your data migration use case by just adding an update sql as a migration script. SQL Compare will then run that update script before applying all other changes. The documentation site explains more about how the new feature works. Let me know if you have any other question :- ) Cheers, Ruchika / comments

Hi Brian/Mattias, It sounds like you're both using MigrationsV1: http://www.red-gate.com/supportcenter/c ... Migrations There is a new beta version of Migrations that the team is currently working ...

0 votes

How can we help you today?

Ruchika

Comments