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

78 results found

  1. I have only a single instance of Ssms.ex, but SSC 2.1.0.31 claims there are multiple open.

    defect

    0 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  fiona.gazeley responded

    I am closing this request as it was raised in 2011 and has zero votes.

  2. support for SQL Compact Edition in SQL Compare

    Increasingly, developers will be using the latest version of SQL Compact Edition to do local development, and want to use SQL Compare to generate an update script for the server.

    41 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. linking static data doesn't show changes in commit tab

    This is more a bug than suggestion. I'm using SQL SC 2.0.3.13 against VSS 8.0.50727.42.
    Apparently, checking tables to be linked is having no effect except that the same tables are checked when I return to the link data screen. Nothing appears in the commit tab.

    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…)
    2 comments  ·  Static Data  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Changing default source control server in Link Database to Source Control

    We have migrated to a new server. Everytime I want to link a DB to source control, the old server comes up as the default in the screen "Link Database to Source Control". How can I change this default behaviour?

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. Auto-init new Mercurial repository

    Currently during the link procedure if I just create a new folder and point to that the link will fail with "abort: There is no Mercurial repository here (.hg not found)!" what is fair enough (and "Open Command Prompt..." helps a lot) but I think it would be great it SQL Source Control can automatically resolve this by creating a repo on its own.

    0 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  fiona.gazeley responded

    I am closing this request as it was raised in 2011 and has zero votes.

  6. Kindel/Books integration

    Since we (DBA/DEV types) have either a load of SQL books floating about, as well as book marks into good SQL sites. We also use the snipets manager in SQL Prompt it would make sense for there to be a connection to bookmarks in books/websites as we use intellisense or snipetts. Likewise have a postback to the forum of 'good bits' into the Snippets repository. From the respository we need an RSS feed on new stuff.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. Allow me to sort the history by clicking on the column header (author, comment, etc.)

    If you look at the history to select a specific version it could be useful to make the grid sortable (on version, date,author,comment DESC/ASC) .

    Then we could sort based on the comment, this would allow to search for specific '5.1' tag or 4.2 tag..

    0 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  ·  History/Log  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  fiona.gazeley responded

    Closing this request since it has been open for 6 years and has zero votes.

  8. Error: Transaction context in use by another session

    My setup went smoothly. I create a new sp on datatabase server, "Comit Changes" then I can see it in TFS. I run into error when I modified the sp from TFS, then go to SQL Source Control and do try to "get Latest". First I got error MSDTC not available, I then started MSDTC services, now i got different error "Transaction context in use by another session". Can you help?

    18 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Option to force users to enter a comment when committing changes

    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…)
    3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  AdminRedgate Administrator (Admin, Redgate) responded

    We believe this needs to be setup on your source control system and not on the SQL Source Control client.

    For SVN users, configure a pre-commit hook to require comments.

    For TFS users, this would be done through a policy, but we currently ignore these. If this is something you would like, please vote/comment at http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/726952-evaluate-tfs-policies-when-committing-db-changes.

    Thank you!
    Stephanie Herr :-)
    SQL Source Control Project Manager

  10. Make connected database more obvious in UI

    Because this product can execute DB changes in bulk, it is essential to highlight clearly the connected database (particularly if it is a Production instance!).

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  AdminRedgate Administrator (Admin, Redgate) responded

    We do NOT recommend linking production databases to source control. Changes should be made on your development instance that is linked to source control. These changes should be deployed to your other environments (Test > Staging > Production) using SQL Compare.

    FYI – Have you heard about our NEW SSMS Integration Pack, http://www.red-gate.com/products/ssms_integration_pack? If you have SQL Compare, this is a free tool that allows you to deploy changes quickly from SSMS.

    If you want, you can comment/vote on the following suggestion:
    Indication of current server / database in source control pane would be useful, http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/464497-indication-of-current-server-database-in-source-

  11. Two databases linked to same image, not synch'ed

    Have the same db on multiple servers. Updated it on one, when to the others, not showing as different even after refresh.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. Modify comments in history

    Displaying the History is awesome, but it would be nice to be able to modify the comments right there in the history window.

    9 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  ·  History/Log  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. able to see the history and do a compare between two versions in the repository

    It would be awesome to be able to see the history and do a compare between two versions in the repository.

    5 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. Use sys.objects create/modify date to get new changes quicker

    Using sys.objects you could determine objects which have been created/modified since the last check to speed things up

    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…)
    declined  ·  3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. v1.0.1.13 hangs on commit to TFS source control

    Trying to commit large number of changed objects to source control causes complete hang of RG Source and SSMS. I have to halt SSMS in Task Manager, and none of my changes are committed. The same TFS, SQL Server, and db are accessible and usable via other SQL Source integration (ApexSQL Edit and VS2010). Only difference is a different local and TFS path for our RG testing. Otherwise this should work.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  AdminRedgate Administrator (Admin, Redgate) responded

    Did you have this problem with previous versions? Please get in touch with support@red-gate.com if you are still experiencing this problem.

    We have seen this problem caused by interactions with some other software… Do you have any of the following installed on your machine?
    - Microsoft Security Essentials
    - Windows Indexing Service
    - Virus scanners
    - Anti Trojan software

    If so, could you make sure they are excluding our directory
    C:\Documents and Settings\\Local Settings\Application Data\Red Gate\Logs\SQL Source Control
    or
    C:\Users\\AppData\Local\Red Gate\Logs\SQL Source Control

    Please let us know if excluding this directory fixes the issue.

  16. Modifying a table makes it disappear from the tables list

    Whenever I modify an existing table, the table disappears from the Object Explorer. If I refresh the tables list in the Object Explorer it reappears...but c'mon, that's ridiculous. The only thing you should be doing to the Object Explorer is marking items that have been modified. If you want to help here, then refresh the list when I add something so it appears (something Microsoft never implemented).

    Note: this only happens when you FIRST edit a table (i.e. subsequent edits to the table after your modified icon is on the table icon don't cause this issue).

    14 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  Michelle Taylor responded

    We have attempted to fix this behaviour a few times now – if it’s still occurring, we would like to investigate this as a bug rather than a feature request. If you have seen this recently, can you please email support@red-gate.com with details?

  17. View change history (TFS) on a per entity basis within Management Studio, with selective rollback

    I understand the difficulties that would exist with rolling back to previous versions of tables based on changes that may have occurred to data, relationships, etc., and rolling back sprocs/functions would have similar potential consequences. But being able to view a change history per entity and have the option to revert has got to make it into the feature pipeline if it's not already...

    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  ·  History/Log  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. option to lock objects instead of creating new versions

    Using TFS as source control, when more than one person is working on the same object (procedure) it causes multiple files to be created. Would like an option to resolve conflicts instead of creating additional versions in the source control.

    0 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…)
    3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  19. Support for other VS Compliant Source Code Systems? I use SourceGear Fortress...

    Why don't you pull from the registry's list of currently installed SCC providers instead of using only Subversion and TFS? If the SCC provider is VS compliant, then why not?

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  20. Initializing of static table content

    Initializing of static table content, ie global options, tables which contain type information

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    declined  ·  AdminRedgate Administrator (Admin, Redgate) responded

    I do not understand this suggestion. Are you looking to source control the contents of a table? E.g., static, reference or lookup table content. If so, please vote/comment on this suggestion, http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/457874-source-control-data-data-folder-is-blank-?ref=title, which also explains the workaround for using SQL Data Compare Pro to do this until we implement this in SQL Source Control.

1 3
  • Don't see your idea?