Activity overview
Latest activity by Gareth_B
SQL Source Control 5 is available on Check For Updates!
SQL Source Control 5 is now available via our Check For Updates mechanism.
It's a pretty exciting release, including improved migrations support for all version control systems.
For more details, c...
Hi m,
I'm afraid that capability doesn't exist within SQL Source Control yet.
If you'd like to suggest we add it, it'd be great to make that request on our uservoice forum.
In particular, there is already a request to "Change remote branch to pull and push from with Git", which you may like to vote on. / comments
Hi m,
I'm afraid that capability doesn't exist within SQL Source Control yet.
If you'd like to suggest we add it, it'd be great to make that request on our uservoice forum.
In particular, there is ...
Hi Alex,
I noticed a copy/paste error in the steps I put before, so they may have been misleading. Can I just confirm that you put the "EnableObjectLocking" setting to "False"?
If so, I'll see what other options we may have for you. / comments
Hi Alex,
I noticed a copy/paste error in the steps I put before, so they may have been misleading. Can I just confirm that you put the "EnableObjectLocking" setting to "False"?
If so, I'll see what...
Hi Alex,
If you're not using the Object Locking feature, it may be worth turning it off completely. We recently had another customer with similar performance issues to yours, and this helped them.
To turn the feature off:
1. Close Management Studio.
2. Go to the SQL Source Control config files folder. By default, this is located at %localappdata%Red GateSQL Source Control 4
3. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
4. Below the EngineOptions version line, add:
<EnableObjectLocking>False</EnableObjectLocking>
The file is case sensitive. Don't change the capitalization of the text.
Ignoring any comments (indicated with <!->), the final file should look like this:
<EngineOptions version="3" type="EngineOptions">
<EnableObjectLocking>False</EnableObjectLocking>
</EngineOptions>
The example above doesn't include any extra lines you may have included. For example, you may have included additional lines to set up change logging.
5. Save and close the file, and reopen Management Studio.
I hope that helps! / comments
Hi Alex,
If you're not using the Object Locking feature, it may be worth turning it off completely. We recently had another customer with similar performance issues to yours, and this helped them.
...
Hi khuber,
You're spot on, this is because of using SSH.
I'm afraid that's not something we currently support in SQL Source Control, so you'll have to continue pushing using git bash.
If you'd like us to add support for SSH, please post a new suggestion on our Uservoice forum. / comments
Hi khuber,
You're spot on, this is because of using SSH.
I'm afraid that's not something we currently support in SQL Source Control, so you'll have to continue pushing using git bash.
If you'd like...
Hi Opus,
You certainly can - a number of comparison options can be changed on the Setup tab within SQL Source Control, including "Ignore Statistics".
Hopefully this documentation page will help: https://documentation.red-gate.com/disp ... on+options
If you're using an older version of SQL Source Control (earlier than 3.8.4) then you'll have to access those options in a slightly different way. / comments
Hi Opus,
You certainly can - a number of comparison options can be changed on the Setup tab within SQL Source Control, including "Ignore Statistics".
Hopefully this documentation page will help: ht...
Hi foobarred1,
It sounds like the Static Data feature may be useful for you. Here's a link to the documentation for that: https://documentation.red-gate.com/disp ... tatic+data
Is that helpful? / comments
Hi foobarred1,
It sounds like the Static Data feature may be useful for you. Here's a link to the documentation for that: https://documentation.red-gate.com/disp ... tatic+data
Is that helpful?
Would it be possible to set up a separate database for these objects, rather than using tempdb?
If that's an option, SQL Source Control can be configured to use that database (this will have to be done for each of your developers).
Instructions for how to set this up can be found here: http://documentation.red-gate.com/displ ... +databases / comments
Would it be possible to set up a separate database for these objects, rather than using tempdb?
If that's an option, SQL Source Control can be configured to use that database (this will have to be ...
SQL Source Control 4 is available on Frequent Updates!
SQL Source Control 4.0 is now available to users on our Frequent Updates channel.
This major release includes all of the improvements made in SQL Source Control 3, and adds one of our most requeste...
Hi Tim,
I'm afraid we don't currently support the Team Explorer 2015 client, so you won't be able to connect with this in SQL Source Control.
We're looking into this at the moment, and hope to be able to offer support for Team Explorer 2015 in the very near future.
In the meantime, would it be possible for you to install Team Explorer 2014? / comments
Hi Tim,
I'm afraid we don't currently support the Team Explorer 2015 client, so you won't be able to connect with this in SQL Source Control.
We're looking into this at the moment, and hope to be a...