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

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
  1. Keep Static Data Stored in PK Order

    When storing the data items in files, it would be good to keep everything in PK order so that changes are easier to spot. Historical order is less important when working with static data.

    90 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. I am looking for the report to track who has made the changes and not checked in.

    Hi,

    I need to know who all has not checked in/committed the code the code.

    As we have so many databases to work on and its very hard to see one by one

    Thanks,
    Vijay

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
  3. Stop forcing acceptance of Database Comparison options in Get Latest tab

    Long time user of Redgate Source Control and a really annoying feature is when I'm on the Get Latest tab and there is a change to the Database Comparison options in source control. I can only select the Database Options changes to Get Latest. I cannot opt to get any of the other objects until I 'get' the database options from source control. This is not what is needed. The choice of whether I get the database options should be down to me and I shouldn't be forced to do it. Please make it the same as all other objects…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add the ability to use windows certificate store to avoid error "A certificate is required o complete client authentication"

    Bitbucket allow to use Selfsigned certificate but you need to add on the server trusted store. With the Bitbucket version 5.3.1 the Source control when push is throwing an error "failed to send request: A certificate is required o complete client authentication". and souce control doesn't have the ability to use trusted store.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  5. The ability to generate a list of objects to commit in Commit tab as well as in 'Get latest' tab.

    If the list of objects to commit run over a page to several pages, it can be difficult to confirm exactly what I'm committing. I like the ability to generate a report list to show all objects as well as selected objects in the Commit tab. It would be nice to have same ability for 'Get latest' objects as well.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Newly added objects no longer have a blue ball beside it in the object explorer unless I do a refresh from the SQL Source Control tab.

    Connecting to a Subversion repository SQL Source Control used to refresh the Object Explorer and show newly added items at the bottom of the list with a blue ball next to it. Since the last version update, I have to manually refresh the Object Explorer to get the newly added item to show up and there is no blue ball next to it unless open SQL Source Control and hit refresh there.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. command line to view all uncommited changes so that we can email a report of all uncommited chnages

    It will be helpful to see or email a report of all uncommited changes by a developer so that we can take actions accordingly

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Link to Git does not allow text entry on 2nd DB

    When linking a 2nd (and all subsequent) database to Git - the text entry for the folder is locked (cannot type into it)

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  9. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
  10. Would be nice to see what filtered objects are under source control (even if they are committed)

    When using filters in SQL Server it would be nice to see what objects are under source control (even if they are committed, maybe with a yellow dot). Currently only uncommitted objects under source control are indicated.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. allow to select/unselect dependent objects on commit

    On commit, there is a button to select/unselect all dependent objects. It would be good to have select/unselect basically a check box to tick or untick the dependent object. This will allow me to select specific dependent object I wish to control not all.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  12. filter

    Allow object types same as that of SQL server database objects. Example, I would like to include some functions under "Table-Valued functions" under the object type "Function". It would be good if there is a tree structure for each object type same as that of SQL server database structure.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  13. SourceControl occupies gigabtyes of old files

    Today, my Windows C: device was 99% full. During the search of the biggest files (which were the Windows/assembly/ folder) I noticed gigabytes of SQL Source Control files! Back to Source Control Version 3.x and 4.x even though we already updated to 5.x. Source Control does not clean up old files.

    Directories I found old Source Control files:

    C:\Windows\Downloaded Installations\
    C:\ProgrammData\Downloaded Installations\
    C:\Users\...\AppData\Local\Red Gate\

    Please provide a function do uninstall all those old files that occupy even gigabytes of disk space storage. Thank you!

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add 'Work Item Number' to the History screen for TFS users

    Add a column in the results for TFS customers so that they can see what Work Item was associated with the changeset

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
  15. See incremental changes made before committing

    When working with an object, there is a chance that another developer has made modifications as well since many developers work off of the same database.

    When committing, it would be nice to be able to see a history of modifications. Each time an object is modified (F5) take a commitable snapshot of that object.

    When a developer goes to commit, they could see the different times an object was modified and commit all at one time or commit the individual changes made over time. Doing a commit will roll-up all previous commits made.

    Example:
    Day 1: Dev A: Adds…

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
  16. Option to use modification date as the commit date

    With SQL, when you modify an object, that object is now out there to be used or tweaked by other developers. Committing it is really just a statement of, I'm done working with this object and here's what I've done.

    We have the problem of not committing objects as timely as we should. We make a modification and go our way until we realize a week later, we forgot to commit. So we commit, but the date time stamp of the commit is not helpful. That is just when the developer remembered.

    I think it would be much, much more…

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
  17. Feature which should enforce user to lock the object before editing when administrator enables the restrictive policy for the users

    Feature which should enforce user to lock the object before editing when administrator enables the restrictive policy for the users

    If it is there it will be very much helpful for most of the development projects not testing and production.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. Data warehouses need source control too! (Azure SQL Data Warehouse / PDW)

    Add source control support for Azure SQL Data Warehouse. I'd love to be able to source control my data warehouse schema.

    37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. history rename

    Treat object RENAME as Source Control (TFS) file RENAME not Drop & Add which deletes Source Control history of the object/file

    More details can be found here: https://redgatesupport.zendesk.com/hc/en-us/requests/88809

    68 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base