Skip to content

SQL Source Control

Welcome to the SQL Source Control feature suggestion list. Find out more information about SQL Source Control at http://www.red-gate.com/products/sql-development/sql-source-control/.

If you have any questions, need help or have found a bug in SQL Source Control, please review our support information http://redgatesupport.red-gate.com/home.

To get new features, performance improvements and bug fixes as soon as they’re available, you may want to turn on frequent updates: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Source Control?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

179 results found

  1. 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 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Support Additional Source Control Systems  ·  Admin →
    completed  ·  Anonymous responded

    I’m going to mark this as complete, please do contact us if you’re still having issues.

  2. Git - View Version History in SSMS

    Currently we cannot view history of objects from SSMS using Redgate with Git as repository. I think this is a required feature. Also, we cannot add comments while commiting. Can these two features please be considered to be added in future releases.

    36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  History/Log  ·  Admin →
    completed  ·  Elizabeth Ayer responded

    Viewing Git history and adding comments for commit are now available in SQL Source Control 4.1 and higher. Thanks for your patience!

  3. Improve speed of getting latest changes and updating for large databases

    It takes 5mins to update the latest changes on my insanely fast computer. Although getting the latest changes are OK but registering base and calculating changes take ages! Please improve :)

    50 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  4. Faster way to exclude all tSQLt content

    It takes a while to setup all the exclude filters, and this time is worse when the solution to a problem is to unlink and relink. Provide a way to quickly exclude tSQLt content and/or save / restore filters.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Initial Setup  ·  Admin →

  5. Support Vault 7

    SourceGear Vault 7.0 is out and now SQL Source Control no longer works. "Server edition is correct, but the version is wrong."

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Support Additional Source Control Systems  ·  Admin →

  6. 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 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Better Support for Shared Db Dev Model  ·  Admin →
    completed  ·  fiona.gazeley responded

    In the Global Options you can choose to allow SQL Source Control to be open in multiple Management Studio windows

  7. svn version 1.8

    Please add support for the current version of svn (1.8)

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Support Additional Source Control Systems  ·  Admin →

  8. Migrations from Working Folder link

    In the "Link to source control" screen there are a number of options.

    We use branches, so our working folder is always the most relevant to what we are doing.

    When we point the link to the WorkingFolder, everything is great, however, the "Migrations" tab is not available for this type of connection.

    This is a pity, because we need to create a migration script that will update the main trunk, when we merge our branch back in.

    Please enable the Migrations feature for the "Workingfolder" type of link.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Initial Setup  ·  Admin →
    completed  ·  Elizabeth Ayer responded

    I am delighted to let you know that this is now released! You can now create migrations scripts even when you’re using working folders.

    If you don’t have SQL Source Control 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!

  9. Intellisense when typing table with underscores (My_Table)

    I have a table called My_Table.

    I should be able to just type "mytab" and have Sql prompt recognize that as an option in intellisense, like devart SQL Complete does. Currently, it gives me no suggestions.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  10. 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 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    In 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.

  11. Allow objects to be committed without their dependencies

    I am working on a project that is an enhancement to an existing database that is controlled by an external party. I am referencing objects that I have no control over via foreign keys, presently I cannot commit the foreign keys to source control unless I also commit the dependent objects. I do not want to commit these as I do not control them.

    Would it be possible to have some mechanism that permits me to commit my changes without the dependencies, something like an override checkbox for the default behavior that will also place messages in the notification box…

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    completed  ·  James Billings responded

    The latest frequent-update version of SQL Source Control (4.0.6.179) allows you to default the checkbox behaviour to off. To do this, you’ll need to edit your UI Options file (RedGate_SQLSourceControl_CommonUI_UIOptions.xml) which you’ll find in localappdata\Red Gate\SQL Source Control 4 and add a tag called IncludeDependenciesCheckbox, like this:

    <IncludeDependenciesCheckbox>False</IncludeDependenciesCheckbox>

    If the value is false, then the checkbox will be un-set by default.

  12. Support Getting Latest Migration Scripts

    According to Red Gate support, migration scripts only run when using SQL Compare, not when using Get Latest within SQL Source Control. Therefore if I have data, real or test, in every development instance, the Get Latest tab is useless in the product and I must use SQL Compare to deploy the changes. I can't imagine it would be too difficult to just run the migration script when using Get Latest.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    Migration scripts are used in SQL Source Control when Getting Latest. Once you click on the “Get Latest” button, you should recieve a warning about the migration script. If it fails, there will be an option to edit the script it was trying to run. The best thing to do is review the script and execute it in SSMS. If there’s an error, it may be a syntax error within the migration script. Once it is corrected, you can execute the script, then refresh the Get Latest tab and you should be in synch.

    I’m sorry about the confusion.

  13. 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 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Initial Setup  ·  Admin →

  14. Ability to link a change to defect in TFS

    Provide a way to link a change during commit to defect in TFS and show it in the history window

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  History/Log  ·  Admin →

  15. Source Control bug: Changes to Commit icon

    This is a bug:
    We recently upgraded source control from 1.x to 3.x.; with the new version the icon that indicates there are changes to commit keeps coming up within minutes after actually doing a commit - and on objects that have NOT undergone a structural change. What's going on? Please fix this.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Admin →

  16. Where can I enter credentials for TFS access

    I'm missing an option to add credentials to TFS. Is it not there?

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  17. Option to store the "Version", "Linked to" and "Migration folder" in a file not the database

    Currently Source Control information is stored in database extended properties in the database being source controled. This requires Alter Database. In production those of us who use RedGate for Source Control, do NOT have Alter database because only the sys admins have that. And they do not want to bother with RedGate as they are just acting as auditors not database developers in production. Other environments we have full rights, just not production. It would be great to have an option to store the "Version", "Linked to" and "Migration folder" in a file not in Extended properties in the database.

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Admin →
    completed  ·  AdminMichael Upton (Development Lead, Redgate) responded

    Sorry that this has taken so long to deal with, but I’m pleased to say that the latest version of the migrations feature no longer requires extended properties on your database.

    This means that as of version 5.1.1 of SQL Source Control, Alter Database permissions are no longer required.

    Mike Upton
    Technical Lead | SQL Source Control

  18. Support SQL Server Management Studio 2012

    Allow SQL Source Control to work on SSMS 2012, where SSMS 2008 and 2012 are both installed on the same machine

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Initial Setup  ·  Admin →

  19. Excluding "starts with underscore" filters out all objects

    I can find no guidance on filter patterns. We have a lot of "temporary" tables which start with an underscore. We've previously used object filters to exclude anything which starts with an underscore. This now excludes all objects in the database, presumably because it's using SQL wildcards. Is the filter syntax SSC uses specified anywhere?

    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  Admin →
    completed  ·  Gareth Bragg responded

    As of SQL Source Control 3.8.13, filter rules now support the standard T-SQL LIKE syntax for wildcard characters (‘%’, ‘_’, ‘[abc]’, and ‘[^abc]’ – see MSDN for details).

    To include wildcard characters explicitly in a filter, they can be escaped with square brackets.

    ‘Equals’ and ‘Does not equal’ operators will not treat those characters as special wildcard characters.

  20. Vault 6

    Support Vault Server version 6.0 that came out recently. Currently when trying to connect against that version, SSC responds with an error of "unsupported server version". It would be nice to make SSC 3.x work with Vault 6.x.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    10 comments  ·  Support Additional Source Control Systems  ·  Admin →
2 4 5 … 8 9
  • Don't see your idea?