179 results found
-
The browse button for the Source Control Folder on Link to Source Control pane
The browse button makes using the product so much easier. Thanks for adding it.
1 voteGlad you like it. This is available in v2.2+ for SVN, TFS, and Vault. :-)
-
Make Edit Filter Rules feature easier to find
I accidentally tripped over the right click menu that allows you to edit filter rules after trying earlier in the day to find it and giving up. Suggest adding a button to the UI so it is more obvious.
1 voteAs of SQL Source Control 3.8.11, you can access the ‘Edit Filter Rules’ option from a few places:
- A button on the Setup tab, under “Options just for this database”
- Through the right click menu in the Management Studio Object Explorer
- Through the right click menu on the SQL Source Control changes list
-
Fillfactor bug
Sql Source Control 3.0.5.7 stopped including the fillfactor index options on table scripts. Every table shows a change now. Sql 2005 database level 80
1 voteSQL Source Control v3.0.5.7 includes a mechanism to allow comparison options to be configured – including Ignore Fill Factor. To get this version, please run Check For Updates from the Help menu in SQL Source Control.
Comparison options can now be set via a configuration file in your database repository’s Working Base folder. The following article describes how to configure this option: http://www.red-gate.com/SupportCenter/GeneralContent/knowledgebase/SQL_Source_Control/KB201202000521
Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often, but we believe this configuration file procedure should help users in the interim.
If you’d like to see an options dialog exposing these settings in SQL Source Control, please vote on the following idea – https://redgate.uservoice.com/admin/forums/39019-sql-source-control/suggestions/2615460-add-an-options-dialog-to-allow-configuration-of-co – and let us know which options you’d like to see exposed in the dialog.
-
Clicking on popup detail resizes SSMS window
When I click on the popup window telling me that is is done getting latest for my database in the background, when I click on the (click here to go to the database) link, it resizes my SSMS window (almost looks like it does the restore down button between the x and minimize button in the upper right.
1 voteThis bug was fixed in SQL Source Control v3.0.11. Please download this version from the ‘Check for Updates’ option in the SQL Source Control Help menu.
-
SQL Source Control For Data Updation
We have gone though SQL source control and it workd perfectly with our Mercurial repository for schema changes. We also want some data changes to be source controlled like in some master tables , we have added some values. We want that these values should be added in the target database with the schema changes when the target db update itself by taking latest, so this type of feature i available in RedGate or we have to do some manual work for data changes. Kindly guide. Thanks
1 voteThis feature is implemented as the Static Data feature of SQL Source Control. More details on https://documentation.red-gate.com/display/SOC5/Link+static+data
-
Using SSC 3.0.11.3531. Bug in static data
When updating static data in source controlled table i need to disconnect and reconnect registered server in object explorer before Commit Changes screen picks up change.
Also seems to affect other changes
1 voteI can no longer reproduce this, I believe this was resolved in the years since it was created.
-
Using SSC 3.0.11.3531. Bug in static data2
When updating static data in source controlled table i need to disconnect and reconnect registered server in object explorer before Commit Changes screen picks up change.
Also seems to affect other changes
1 voteI can no longer reproduce this, I believe this was resolved in the years since it was created.
-
Using SSC 3.0.11.3531. Bug in static data3
When updating static data in source controlled table i need to disconnect and reconnect registered server in object explorer before Commit Changes screen picks up change.
Also seems to affect other changes
1 voteI can no longer reproduce this, I believe this was resolved in the years since it was created.
-
I have my database objects in an existing SVN Repository, how can I link SSC to that?
We already have our database in SVN, is there a way to access that repository?
1 voteIf you were using SQL Compare to create a scripts folder and source control that in SVN, then you can link your database to this repository. Information is at http://www.red-gate.com/supportcenter/content/SQL_Source_Control/knowledgebase/using-a-scripts-folder.
-
Provide access to files for uncommitted changes
We use Code Collaborator to peer review our SQL code before we submit to our version control (Perforce). This is typically done using a pending changelist, which is probably specific to Perforce. However, it would be sufficient to merely have SQL Source checkout and update the files in the working directory before/without committing.
1 voteIn SQL Source Control v3.4, there is an option to link to a working folder. If you use this option, on the commit tab, you can “save” your changes to the working folder. This scripts out the objects to files. You can then use your own tool to review the changes and add them to the changelist and commit them using your own source control system’s client tool.
-
Fix for error msg: "SQL Source Control is disabled because you have multiple instances of SSMS open".
When other instances of SSMS are closed, Source Control should be re-enabled.
1 voteIn the Global Options you can choose to allow SQL Source Control to be open in multiple Management Studio windows
-
how to setup a fresh database by using red sql source control
This is just a thought and I am in desperate need.
Can we do a fresh step of a database by using red sql source control.
even we generate a single script from tables and stored procedure folder but constraint will miss match.
Kindly share your views on this.
1 voteI’m going to mark this as complete, please do contact us if you’re still having issues.
-
When I check commit changes I used to get the TFS changeset number which was really useful. Now I don't seem to. Has something changed?
Where has TFS changeset notification gone?
1 voteThis is now fixed in the latest frequent update release.
-
Commit Dialog: Highlight selected object
The selected object in the list of items to be committed used to be highlighted.
I'm on v 4.1.13.94, using the SVN connection. selected item is no longer highlighted.
Maybe it's me? is there a config option I accidentally set?
1 voteThe release later today should change this to a lovely shade of light blue, and be more visible.
-
When we do SQL Compare from source control to source control, the URL of our repository appears at the end of the script - can it be removed
When we use SQL Compare from source control to source control, the URL of our source code control repository appears at the end of the script. This is causing security issues for us. There should be a non-manual way to remove this link.
1 voteI am delighted to let you know that this is now released! With Migrations in SQL Source Control 5, the URL to your repository no longer appears.
If you don’t have the tool installed, you can download it from http://www.red-gate.com/products/sql-development/sql-source-control/.
If you already have SQL Source Control you can get the new version via Check for updates in the Help menu of SQL Source Control inside SSMS.
You can see other Migrations examples and tutorials here: https://documentation.red-gate.com/display/SOC5/Migration+script+examples
Thank you for sticking with us while we worked on this, and please keep the feedback coming!
-
Access My Working Folder From SSMS
A link to the windows folder where the database repository is stored would be good too.
0 votesSQL Source Control has a hidden option that allows you to open the linked database’s working folder from SSMS. See comments for how to find this option.
-
Bug: renaming a SP has unlinked it from version control
I have a stored procedure sprunfacttoreport. I renamed it to sprunfacttorpt and now it is no longer in version control and changes are not propagated.
I don't mind if rename is handled by delete and add rather than svn move, but I would like every object I create to be in version control! :)
0 votesI’m glad you were able to figure it out.
Do you have your tab docked? If it’s docked, then it doesn’t auto-refresh.
-
Unable to change migration settings on the 'Setup' tab v3.0.0.50
After connecting Source control to the database, I am unable to change the Migration settings on the 'Setup' tab.
0 votesMigrations in SQL Source Control 5 no longer requires a separate repository, so you should now be able to use it with your setup.
If you don’t have the tool installed, you can download it from http://www.red-gate.com/products/sql-development/sql-source-control/.
If you already have SQL Source Control you can get the new version via Check for updates in the Help menu of SQL Source Control inside SSMS.
You can see other Migrations examples and tutorials here: https://documentation.red-gate.com/display/SOC5/Migration+script+examples
If you’ve stuck with us since 2011, many thanks. If not, maybe now is a good time to give the product another look? :-)
-
TFS Migration script unusable with custom port
When clicking the "Add a Migration Script" link on the Commit Changes tab, the TFS url and port are read only. As we use TFS on port 80 instead of port 8080, we cannot use this feature.
The same applies when setting up the link on the Setup tab.
0 votesMigrations in SQL Source Control 5 no longer requires a separate repository, so you should now be able to use it with your setup.
If you don’t have the tool installed, you can download it from http://www.red-gate.com/products/sql-development/sql-source-control/.
If you already have SQL Source Control you can get the new version via Check for updates in the Help menu of SQL Source Control inside SSMS.
Thank you for sticking with us while we worked on this, and please keep the feedback coming!
- Don't see your idea?