Comments
Sort by recent activity
Hi,
That's not a scenario that we have tested since SQL Source Control tends to be used in development environments.
In that case ideally all source controlled databases should be in the same AG as you can only have 1 Redgate DB.
Bear in mind that object locking also uses a DDL trigger. http://documentation.red-gate.com/displ ... ct+locking
Thank you, / comments
Hi,
That's not a scenario that we have tested since SQL Source Control tends to be used in development environments.
In that case ideally all source controlled databases should be in the same AG as...
Hi,
Large Static Data sets can be problematic with SQL Source Control, as it's mainly meant to source control the schema and small sets of constant data.
One thing you can try is using our DLM Automation tool which has a Jenkins plugin: https://wiki.jenkins-ci.org/display/JEN ... +CI+Plugin
Thank you, / comments
Hi,
Large Static Data sets can be problematic with SQL Source Control, as it's mainly meant to source control the schema and small sets of constant data.
One thing you can try is using our DLM Auto...
Hi Richard,
I am afraid to say, but this is not on the roadmap at the moment.
If you want you can suggest this as an enhancement in our uservoice forum: https://redgate.uservoice.com/forums/39 ... ce-control
That forum is an important source that we consult when deciding what features to add or enhance in SQL Source Control.
Thank you, / comments
Hi Richard,
I am afraid to say, but this is not on the roadmap at the moment.
If you want you can suggest this as an enhancement in our uservoice forum:https://redgate.uservoice.com/forums/39 ... c...
Hi Richard,
I am afraid that this is not possible.
To compare source controlled static data and scripts folders you could use SQL Data Compare: http://www.red-gate.com/products/sql-de ... a-compare/ https://documentation.red-gate.com/disp ... ta+sources
Thank you, / comments
Hi Richard,
I am afraid that this is not possible.
To compare source controlled static data and scripts folders you could use SQL Data Compare:http://www.red-gate.com/products/sql-de ... a-compare/...
Hi Steve,
I have opened a support ticket and I am going to contact you through there.
Thank you, / comments
Hi Steve,
I have opened a support ticket and I am going to contact you through there.
Thank you,
Hi,
This bug has now been fixed in version 4.4.0 of SQL Source Control, which is available on the Frequent Updates Channel.
Please note that the workaround described above still works and there's no real downside to using it so you don't to change configuration back.
Thank you, / comments
Hi,
This bug has now been fixed in version 4.4.0 of SQL Source Control, which is available on the Frequent Updates Channel.
Please note that the workaround described above still works and there's n...
Hi Darren,
There's a bug with the current version of SQL Source Control that causes authentication to fail.
This should be fixed in an upcoming version of of SQL Source Control, in the meantime please try the following workaround:
1 - Close SSMS
2 - Download and install Team Explorer for Visual Studio 2013: https://www.microsoft.com/en-gb/downloa ... x?id=40776
3 - Restart system if asked by the installer to do so
4 - Follow the instructions on the section labeled How to change the version of Team Explorer that SQL Source Control uses on the following webpage: http://documentation.red-gate.com/displ ... e+selected
However rather than typing TFS2010 in the xml file type TFS2013:
<EngineOptions version="3" type="EngineOptions">
<TeamFoundationServerDllOverride>TFS2013</TeamFoundationServerDllOverride>
</EngineOptions>
5 - Start SSMS and attempt to link again
Thank you, / comments
Hi Darren,
There's a bug with the current version of SQL Source Control that causes authentication to fail.
This should be fixed in an upcoming version of of SQL Source Control, in the meantime ple...
Hi,
DeploymentOrder.json controls the order migrations run in during deployment and is primarily for branching + merging, so that when I merge two branches with migrations I can choose which one should be deployed first (so it only changes the order of the migration scripts inside the deployment phase).
If you need those pre and post deployment scripts to run every time you deploy then I am afraid SQL Source Control will not be able to help you.
If you only need each script to run once then it should work. Let's assume that you start from having everything in your repository deployed. If you commit a migration script then commit some schema changes, when you come to deploy then we'll run the migration script followed by the other schema changes. If you were to commit another migration after the schema changes, then it won't necessarily run at the end of the deployment - it will only run after the schema changes which it depends on.
Thank you, / comments
Hi,
DeploymentOrder.json controls the order migrations run in during deployment and is primarily for branching + merging, so that when I merge two branches with migrations I can choose which one sh...
Hi,
I am afraid that Migration Scripts in SQL Source Control only act at the deployment stage.
SQL Source Control 5, which is going to be released in the next few weeks, will feature a new approach to migrations, however they will still only act at the deployment stage.
For more information regarding migrations in SQL Source Control 5 please read the following: https://documentation.red-gate.com/disp ... ripts+work
Thank you, / comments
Hi,
I am afraid that Migration Scripts in SQL Source Control only act at the deployment stage.
SQL Source Control 5, which is going to be released in the next few weeks, will feature a new approach...
Hi,
I am sorry that you are having issues while using SQL Source Control.
Can you please try the suggestions in the following documentation pages: http://documentation.red-gate.com/displ ... ur+machine http://documentation.red-gate.com/displ ... e+selected
?
Thank you, / comments
Hi,
I am sorry that you are having issues while using SQL Source Control.
Can you please try the suggestions in the following documentation pages:http://documentation.red-gate.com/displ ... ur+mach...