| Author |
Message |
swinghouse
Joined: 12 Sep 2011
Posts: 82
|
 Posted: Tue Jan 08, 2013 5:53 pm Post subject: What's a good way to package migration scripts? |
 |
|
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? |
|
| Back to top |
|
 |
chirayu
Joined: 17 Sep 2012
Posts: 22
|
| Posted: Thu Jan 10, 2013 12:19 pm Post subject: |
|
|
Hi Mattias
There is certainly more documentation from SQL Source Control that I can point to you in the meanwhile: http://www.red-gate.com/supportcenter/content/SQL_Source_Control/help/3.1/SSC_Working_With_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!
_________________
Chirayu Shishodiya
Software Engineer - Deployment Manager
Red Gate |
|
| Back to top |
|
|
swinghouse
Joined: 12 Sep 2011
Posts: 82
|
| Posted: Thu Jan 10, 2013 3:19 pm Post subject: |
|
|
Hi Chirayu,
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 |
|
| Back to top |
|
|
chirayu
Joined: 17 Sep 2012
Posts: 22
|
| Posted: Thu Jan 10, 2013 3:53 pm Post subject: |
|
|
No problem, 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!
_________________
Chirayu Shishodiya
Software Engineer - Deployment Manager
Red Gate |
|
| Back to top |
|
|
swinghouse
Joined: 12 Sep 2011
Posts: 82
|
| Posted: Thu Jan 10, 2013 5:04 pm Post subject: |
|
|
Hi Chirayu,
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/viewtopic.php?p=59707#59707
I added an example to that thread.
/Mattias |
|
| Back to top |
|
|
swinghouse
Joined: 12 Sep 2011
Posts: 82
|
|
| Back to top |
|
|
swinghouse
Joined: 12 Sep 2011
Posts: 82
|
|
| Back to top |
|
|
|
