What's a good way to package migration scripts?
swinghouse
Posts: 120 Bronze 2
Deploying changes in database objects and static table data (as defined in SQL Source Control) works beautifully with Deployment Manager + SQL Source Control + SQL Compare!
However, something I'm a bit uncertain of - and that is a big pain in the *** in my old, manual deployment routine - is how to deal with migration scripts, e.g. INSERT/UPDATE/DELETE scripts which will, e.g., change certain field values or delete certain records.
Do you have any recommendations as to how one could incorporate these scripts in the deployment process? Perhaps there is a white paper that I simply have failed to notice?
However, something I'm a bit uncertain of - and that is a big pain in the *** in my old, manual deployment routine - is how to deal with migration scripts, e.g. INSERT/UPDATE/DELETE scripts which will, e.g., change certain field values or delete certain records.
Do you have any recommendations as to how one could incorporate these scripts in the deployment process? Perhaps there is a white paper that I simply have failed to notice?
Comments
There is certainly more documentation from SQL Source Control that I can point to you in the meanwhile: http://www.red-gate.com/supportcenter/c ... Migrations
Would you please elaborate on your precise use case that you are trying to satisfy with migration scripts? More precisely, what is it that you are trying to achieve which SQL Source Control migrations that it does not already support? This could be great feedback that I can pass on to SQL Source Control team.
Thanks Mattias!
Software Engineer - Deployment Manager
Red Gate
Thank you, that link was super helpful!
I hadn't spotted the "Add Migration Script for Specific Changes" feature in SQL Source Control! The reason for this oversight is that our current SQL Source Control license is for v. 2.1.1, which doesn't have this feature, and it was only last week that I started playing around with the current version of SQL Source Control.
I'm quite positive that this feature covers everything I need when it comes to migration scripts. Otherwise, I'll post my wish list! :-)
/Mattias
SQL Source Control team are currently working on improving the migrations feature.
If you could give me some feedback regarding which use-case you are using migration feature then that would be great feedback to pass to SQL Source Control team.
Thanks in advance!
Software Engineer - Deployment Manager
Red Gate
Thank you for you super fast responses. Most appreciated!
It does seem like the migration script feature doesn't cover all my use cases - perhaps we simply have some odd ways of doing things!
I spotted a thread over on the SQL Source Control forum that addresses the same issue: http://www.red-gate.com/messageboard/vi ... 9707#59707
I added an example to that thread.
/Mattias
Have you heard anything more from the SQL Source Control team regarding the above? There hasn't been any response in the thread at http://www.red-gate.com/messageboard/vi ... 9707#59707
/Mattias
Thanks!
/Mattias