Red Gate forums :: View topic - Add to a Deployment script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Add to a Deployment script

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bomberbri



Joined: 02 Jan 2013
Posts: 2

PostPosted: Wed Jan 02, 2013 4:38 am    Post subject: Add to a Deployment script Reply with quote

I'm trying to add something to a migration script. I know I can edit it manually but what I thought I might be able to do is where you can right click an object in commit changes tab and choose Add new migration script I thought there would be an option to add to existing migration script? If not how do people manage scripts for projects. We have a situation where developers are working on BAU work and a project. WE would like to be able to keep the project scripts together so at a later date they can be deployed as a package in a migration script or similar. How can I achieve this?
_________________
Cheers Brian
Back to top
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 94

PostPosted: Thu Jan 10, 2013 4:58 pm    Post subject: Reply with quote

I have this question as well.

The current migration script feature is certainly useful, but sometimes we need to script updates/inserts/deletes that don't necessarily correspond to changes in the database structure.

An example, inspired by a recent case:

We needed to update a number of records in our Clients table and the easiest way was to write an sql script.

However, we didn't need to change the structure of the Clients table, we only needed to update some data. Thus, the migration script feature in SQL Source Control wouldn't let us add this script as a migration script.

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



Joined: 04 May 2012
Posts: 2
Location: Cambridge, UK

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

@bomberbri I'm not sure I understand your problem. Why are you unhappy to make a new migration script for new changes to your objects?

@swinghouse we are currently working on a set of improvements to the migration script functionality in SQL Source Control. One of the features of this new functionality is that it will support adding migration scripts not involving structural changes, like your example.
_________________
Matt Turner
Project Manager
SQL Source Control
Back to top
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 94

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

That sounds fantastic, Matt!

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



Joined: 06 Apr 2012
Posts: 3
Location: Salt Lake City

PostPosted: Mon Feb 11, 2013 5:42 pm    Post subject: Reply with quote

I am glad to hear about this too. It's very much needed in our shop Smile
_________________
Greg L. Wright
Sr. DBA \ Consultant
snapjag.com
Back to top
View user's profile Send private message MSN Messenger
Ruchika



Joined: 08 Aug 2013
Posts: 5

PostPosted: Wed Jan 15, 2014 4:38 pm    Post subject: Reply with quote

Hi Brian/Mattias,

It sounds like you're both using MigrationsV1: http://www.red-gate.com/supportcenter/content/SQL_Source_Control/help/3.1/SSC_Working_With_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
Back to top
View user's profile Send private message
swinghouse



Joined: 12 Sep 2011
Posts: 94

PostPosted: Mon Jan 27, 2014 2:54 pm    Post subject: Reply with quote

Excellent news! I will definitely try the beta of Migrations V2.
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