What's a good way to package migration scripts?

Automated deployment for web applications and databases

Moderators: Mike Upton, justin.caldicott, Sean.newham, csmith, chirayu, DavidSimner, david.conlin

What's a good way to package migration scripts?

Postby swinghouse » Tue Jan 08, 2013 5:53 pm

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?
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am

Postby chirayu » Thu Jan 10, 2013 12:19 pm

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/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!
Chirayu Shishodiya
Software Engineer - Deployment Manager
Red Gate
chirayu
 
Posts: 68
Joined: Mon Sep 17, 2012 5:48 pm

Postby swinghouse » Thu Jan 10, 2013 3:19 pm

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
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am

Postby chirayu » Thu Jan 10, 2013 3:53 pm

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
chirayu
 
Posts: 68
Joined: Mon Sep 17, 2012 5:48 pm

Postby swinghouse » Thu Jan 10, 2013 5:04 pm

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/vi ... 9707#59707

I added an example to that thread.

/Mattias
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am

Postby swinghouse » Tue Jan 15, 2013 11:03 am

Hi Chirayu,

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
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am

Postby swinghouse » Tue Jan 15, 2013 11:26 am

Wow, a quick response over at http://www.red-gate.com/messageboard/vi ... 9707#59707 :D

Thanks!

/Mattias
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am


Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests