Redgate

New and returning users may sign in

Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
  • Sign in
  • Sign up

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.

votes
Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Cancel Submitting...
  • Vote for an existing idea ()
  • or
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

  1. Add ability to Merge Static Data

    "Take theirs" and "Keep mine" are an all or nothing option, I would like to have more control over this and be able to keep my new records but take the updated, or keep my updated records but take the new records, for example.

    6 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Static Data  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  2. Prevent "new version" update banner from hiding the tab bar

    After linking a DB to Git, I was trying to get back to the Setup Options that are hidden behind the "Setup" tab/button in the top button bar.
    The bar was hidden behind the Update banner. As a new user, I didn't even know that bar existed, so I didn't know that I could get there by clicking the "Remind me later" option, until I had opened a ticket with support

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  3. Make static data UI sortable / searchable

    With 100s or 1000s of tables it becomes quite tricky to find objects in the static data link / unlink UI. Therefore, I suggest adding a search textbox there as well as making the UI columns (name, key, schema) sortable.

    6 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  4. Fully Support Azure DevOps for SQL Source Control

    I would like to link a local database in SQL Source Control to our Azure DevOps repository. However, as my Azure login has MFA enabled, I am unable to do so. This is a huge pain and I do not want to use GIT as this is a poor workaround to something that should just work (how long has MFA been around?!).

    Please add proper support for Azure DevOps to SQL Source Control, including full support for MFA.

    6 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Azure  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  5. Implement the "IGNORE" rules so that database objects can be completed filtered out of source control

    Introduce something similar to the "IGNORE" rules found in your Schema compare for Oracles solution to the SQL Server Source Control product.
    The problem that exists for those of us with third party databases that have 10's of thousands of objects is that they are not workable using this product because it ONLY applies the filter AFTER it has already tried to extract and manage the ENTIRE database. The "IGNORE" option would allow us capabilities similar to filter but they would be applied UP FRONT and BEFORE the system ever tried to gather and manage every single object in the database. This is important because we actually only desire to ever manage the objects we are not ignoring or filter out. Without this capability the software crashes and runs for hours upon hours working hard on all of these objects that we DO NOT even want to ever manage.

    This has been discussed by Redgate support, developers and product managers and I am hoping your votes will help to get this worked on ASAP as it is mandatory for success in our environment.

    Introduce something similar to the "IGNORE" rules found in your Schema compare for Oracles solution to the SQL Server Source Control product.
    The problem that exists for those of us with third party databases that have 10's of thousands of objects is that they are not workable using this product because it ONLY applies the filter AFTER it has already tried to extract and manage the ENTIRE database. The "IGNORE" option would allow us capabilities similar to filter but they would be applied UP FRONT and BEFORE the system ever tried to gather and manage every single object in the…

    46 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Better Support for Shared Db Dev Model  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  6. Get Latest Error Logging

    When attempting to get latest changes and an error occurs, please be more detailed (e.g table, data, column, etc.) that caused the error that will allow user to correct the error. It is possible the user getting the latest change was the person responsible for the error, making it difficult to trouble shoot when your database is relatively large.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Better Support for Shared Db Dev Model  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  7. Display summary of Static Data differences

    When displaying the Static Data differences in SQL Source Control it would be very useful to show the number of records that are Different/Identical/In Database Only/In Source Control Only.

    When tables have thousands of records it can be difficult to know the scale of what you’re about to check in or get by just scrolling down a long list. A tab displaying the records for each distinct group would be even better.

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  8. add option to view commited deleted object code from repsostiry in SSMS

    Currently there is not easy way to see or restore a deleted object that was committed. The object code is still in Source Control - but no easy way to see or restore it using SSMS.

    1 vote
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  9. Separate comparison options for "Ignore tSQLt framework" and "Ignore tSQLt tests"

    Currently, SQL Source Control and SQL Compare have an option to "Ignore tSQLt framework and tests". We want to create our tests in dev and include them in our stage deployments for regression testing. The current setting ignores the framework AND our custom test code.

    We want the Red Gate tools to ignore only the framework, but not the custom tests. We will manage the framework install separately. Ideally, there would be separate ignore checkbox rule options, one for the framework and another for our tests.

    We have to set the current option to unchecked ("don't ignore") and then set custom filter rules to have only the framework ignored.

    It would help if we didn't have to add custom filter rules to ignore the framework and track the tests.

    Currently, SQL Source Control and SQL Compare have an option to "Ignore tSQLt framework and tests". We want to create our tests in dev and include them in our stage deployments for regression testing. The current setting ignores the framework AND our custom test code.

    We want the Red Gate tools to ignore only the framework, but not the custom tests. We will manage the framework install separately. Ideally, there would be separate ignore checkbox rule options, one for the framework and another for our tests.

    We have to set the current option to unchecked ("don't ignore") and then set…

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  10. Add the ability to swap the compare panes poistions in the View History Window

    This would allow for the option to move the newer revision pane to be on the left and the older revision on the right.

    6 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  History/Log  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  11. snowflake

    Add snowflake support

    17 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  12. SQL Sourse Control Sort Option

    Provide the capability to save the users last sort settings. For example on the Commit tab if I sort by last changed by (asd); the next time I go to the Commit tab it should be sorted by last changed by (asd).

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Support Additional Source Control Systems  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  13. Partially contained databases

    SQL Source Control should officially support partially contained databases

    4 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  14. Agent jobs could be source controlled if we were able to select system tables as static data.

    To allow us to add SQL Server Agent jobs into source control, allow us to select system tables as static data.
    At least dbo.sysjobs, dbo.sysjobsteps and dbo.sysjobschedules in msdb

    4 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  15. Make SQL Source Control external to SSMS

    Make SQL Source Control external to SSMS like SQL Compare. This would allow the developer to use what ever IDE they want to and still commit the changes the same way. I would use SQL Compare to make changes, but it can't do everything SQL Source Control can. Mainly the migration scripts and the pre and post scripts.

    11 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Better Support for Shared Db Dev Model  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  16. Better Git performance

    While it is great the SSC supports Git, I have found that when connected to a large repository, SSC can take forever to commit or do a get latest.

    I have also noticed that the working base and transient folders can grow quite large as the whole Git repo is cloned into these folders. I have had to periodically go in there and have Git compress it's objects so that I can reclaim some disk space.

    I imagine that the performance of SSC is related to the size of the Git repo and I just feel like there is room for improvement in how SSC uses it's Git repos that could increase performance.

    While it is great the SSC supports Git, I have found that when connected to a large repository, SSC can take forever to commit or do a get latest.

    I have also noticed that the working base and transient folders can grow quite large as the whole Git repo is cloned into these folders. I have had to periodically go in there and have Git compress it's objects so that I can reclaim some disk space.

    I imagine that the performance of SSC is related to the size of the Git repo and I just feel like there is room…

    23 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  17. database properties

    Redgate still does not Support Database properties??

    They shuold support properties like (Transaction Isolation level (Read Committed, Snapshot)Ansi Null, Quoted Identifier). These are Crucial. I cannot believe these are not in source control yet. The product has been out since 2006.

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Support Additional Source Control Systems  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →

  18. Disconnect the SOC pane from Object Explorer

    Right now the SOC pane is linked to the database in Object Explorer. The problem in this is that the pane can't work asynchonously to get changes while I move on.

    Give the slow performance of looking for changes and populating the commit tab, can we

    1. Put a drop down in the SOC pane to choose the db
    2. Have the Commit popular process (refresh) be set to work with this database asynchronously. Either allow me to set a polling interval or click the refresh button, but then allow me to move to another tab and continue to work.
    3. Same for Get Latest

    In both cases, I should be able to commit or apply changes and switch to antoher tab to work.

    Right now the SOC pane is linked to the database in Object Explorer. The problem in this is that the pane can't work asynchonously to get changes while I move on.

    Give the slow performance of looking for changes and populating the commit tab, can we

    1. Put a drop down in the SOC pane to choose the db
    2. Have the Commit popular process (refresh) be set to work with this database asynchronously. Either allow me to set a polling interval or click the refresh button, but then allow me to move to another tab and continue to work. …

    10 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  19. Generate a Script rather than Apply changes in the Get Latest tab

    I am using GIT and SQL Source Control. After running "Pull from remote repository" in the Get Latest tab, the only option is to Apply changes which directly updates the database.

    If the changes include something like the classic renaming of a column, it will drop the column and add a new one and I lose data.

    I would like to be able to simply generate a script so I can review it and manually apply it rather than directly update the database.

    17 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →

  20. Custom Formatting

    Allow for custom formatting used by SQL Prompt to also be used when committing code with SQL Source Control.

    3 votes
    Vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
← Previous 1 2 3 4 5 … 29 30 Next →
  • Don't see your idea?

Feedback

25 25 votes

SQL Source Control

Categories

  • CATEGORIES
  • All ideas
  • My feedback
  • Azure 2 ideas
  • Better Support for Shared Db Dev Model 54 ideas
  • History/Log 50 ideas
  • Initial Setup 51 ideas
  • Static Data 55 ideas
  • Support Additional Source Control Systems 37 ideas

JUMP TO ANOTHER FORUM

(thinking…)

  • Searching…

    No results.

    Clear search results
    • DLM Dashboard 160 ideas
    • MySQL tools 21 ideas
    • Oracle 126 ideas
    • Redgate 0 ideas
    • SQL Change Automation 50 ideas
    • SQL Compare 157 ideas
    • SQL Data Compare 62 ideas
    • SQL Prompt 279 ideas
    • SQL Search 78 ideas
    • SQL Source Control 582 ideas

  • Redgate

Redgate
Redgate Terms of Service Powered By UserVoice

Your password has been reset

We have made changes to increase our security and have reset your password.

We've just sent you an email to . Click the link to create a password, then come back here and sign in.