Red Gate forums :: View topic - What's a good way to package migration scripts?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

What's a good way to package migration scripts?

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
swinghouse



Joined: 12 Sep 2011
Posts: 99

PostPosted: Tue Jan 08, 2013 5:53 pm    Post subject: What's a good way to package migration scripts? Reply with quote

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
View user's profile Send private message
chirayu



Joined: 17 Sep 2012
Posts: 60

PostPosted: Thu Jan 10, 2013 12:19 pm    Post subject: Reply with quote

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
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 99

PostPosted: Thu Jan 10, 2013 3:19 pm    Post subject: Reply with quote

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! Smile

/Mattias
Back to top
View user's profile Send private message
chirayu



Joined: 17 Sep 2012
Posts: 60

PostPosted: Thu Jan 10, 2013 3:53 pm    Post subject: Reply with quote

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
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 99

PostPosted: Thu Jan 10, 2013 5:04 pm    Post subject: Reply with quote

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! Smile

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
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 99

PostPosted: Tue Jan 15, 2013 11:03 am    Post subject: Reply with quote

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/viewtopic.php?p=59707#59707

/Mattias
Back to top
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 99

PostPosted: Tue Jan 15, 2013 11:26 am    Post subject: Reply with quote

Wow, a quick response over at http://www.red-gate.com/messageboard/viewtopic.php?p=59707#59707 Very Happy

Thanks!

/Mattias
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group