Options
New user ?? about production migration best practices
bobprobst
Posts: 5 Bronze 1
Using TFS as our repository.
So I've been developing away and checking my code in periodically but now I want to push one or two of those changes out to Prod.
I can generate a migration script based on change sets but what I really want is a change script for just one or two objects not the whole set of changes that I've checked in. So change set 1 changes objects A, B and C. Change set 2 changes object B further and change set 3 changes objects A and D.
But I really just want to push my changes for objects B and C.
Is there an easy way to do this using SQL Source Control Migrations or do I need to use SQL Compare on objects B & C?
And if I use SQL Compare, can I check the script that's generated into source control without saving it to my local check out folder and manually checking it into my migration scripts folder in TFS?
Or do I generate a Migration script for all 3 change sets and manually edit it? Which seems like it's error prone.
Or, am I approaching this all wrong and should only be checking in changes that I want to move to production and then I just have the one change set to run a migration script for?
Hope that's clear!
Thanks for any help you can offer.
So I've been developing away and checking my code in periodically but now I want to push one or two of those changes out to Prod.
I can generate a migration script based on change sets but what I really want is a change script for just one or two objects not the whole set of changes that I've checked in. So change set 1 changes objects A, B and C. Change set 2 changes object B further and change set 3 changes objects A and D.
But I really just want to push my changes for objects B and C.
Is there an easy way to do this using SQL Source Control Migrations or do I need to use SQL Compare on objects B & C?
And if I use SQL Compare, can I check the script that's generated into source control without saving it to my local check out folder and manually checking it into my migration scripts folder in TFS?
Or do I generate a Migration script for all 3 change sets and manually edit it? Which seems like it's error prone.
Or, am I approaching this all wrong and should only be checking in changes that I want to move to production and then I just have the one change set to run a migration script for?
Hope that's clear!
Thanks for any help you can offer.
