Create Deployment Scripts between versions
jleach
Posts: 6
SQL Source Control 3.7.5.328 (can't find the forum for it, sorry).
I have a database set up with git VCS, and am trying to use the Compare tool to create scripts to convert my test copy to match my dev copy.
So, in source control I have a tag v0.1.0.0-t which is where I am now, and I have an older tag v0.0.1.0-t which is where I was.
One would think that I could select v0.1.0.0-t as the source and v0.0.1.0-t as the target and generate a set of scripts that I can then run on my test server to update the database (I don't have access to that target database from my dev machine, so I can't set it as an actual database target).
I've read here: https://documentation.red-gate.com/disp ... ce+control (and various other places), where it says: "You can deploy to a target database, create a new database, or create a change script to update a target source control version."
But, under the Schema Compare/Deploy tab on the Source side, I select Source Control, choose Specific Version, click the ... button, and there's no history. For the Target side, I'm unable to select Source Control.
Can someone explain to me why I can't use this feature? It's really the only one I need, and it appears to be... well, useless.
Thanks
I have a database set up with git VCS, and am trying to use the Compare tool to create scripts to convert my test copy to match my dev copy.
So, in source control I have a tag v0.1.0.0-t which is where I am now, and I have an older tag v0.0.1.0-t which is where I was.
One would think that I could select v0.1.0.0-t as the source and v0.0.1.0-t as the target and generate a set of scripts that I can then run on my test server to update the database (I don't have access to that target database from my dev machine, so I can't set it as an actual database target).
I've read here: https://documentation.red-gate.com/disp ... ce+control (and various other places), where it says: "You can deploy to a target database, create a new database, or create a change script to update a target source control version."
But, under the Schema Compare/Deploy tab on the Source side, I select Source Control, choose Specific Version, click the ... button, and there's no history. For the Target side, I'm unable to select Source Control.
Can someone explain to me why I can't use this feature? It's really the only one I need, and it appears to be... well, useless.
Thanks
Comments
We've opened a support ticket for this question as it will take some troubleshooting to figure out why the history is not showing up. I will be repsonding there right after this response, thanks.
Red Gate Software
US Product Support
Then I uninstalled all of the RedGate tools from my system and attempted to reinstall from scratch, and I can't even do that. Now I get an error upon completion (SQL Source Control 4.1: The path is not of a legal form), and when I try to open SSMS 2014, it tells me that the Integration Pack addin isn't valid.
(note the path in the SSMS startup error: ...Studio12.0\Addins...)