Add to a Deployment script

[bomberbri]

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

[swinghouse]

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

[matt_turner]

@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

[swinghouse]

That sounds fantastic, Matt!

/Mattias

[SnapJag]

I am glad to hear about this too. It's very much needed in our shop
_________________
Greg L. Wright
Sr. DBA \ Consultant
snapjag.com