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

588 results found

  1. Right Click View Changes on object

    Just started using SQL Source Control - If I look at a database which is already withi subversion and I look at a table I can see that it has changes - It would be nice to be able to just right click on that table and select an option to 'View Changes' so that I can quickly see the changes which have been made to that table.

    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  ·  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

  2. Add ability to edit database link

    In our development model we set up a branch for each release of our product in our SCM tool.

    So we need to frequently change the linkage for a DB to the new branch in source control after each release.

    The tool currently doesn't have any edit capability on the linkage, so we are forced to remove and re-add it each time. This is somewhat awkward. Can we get an edit database link feature on the setup tab?

    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…)
    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

  3. BUG: Expended properties (MS_Description) on tables and DB is ignored

    When I add Extended properties (MS_Description) on tables and Database and tries to commit, the changes dosn't Show.
    If I later change a Description on one of the fields in the table, the Table properties changes is shown (and commited).
    I Cant find a workaround for the DB description

    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  ·  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. It would be great to use Source Control with Postgres

    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  ·  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. BUG: Recently edited object disappears from Object Explorer

    Recently edited objects disappear from the object explorer pane after editing an object in designer. For example, changing columns on an existing table which prompts to update a related table will result in the related table being highlighted and the table I was editing disappear from the object explorer pane. The missing object only reappears if I manually refresh the pane. If I don't notice that this has happened, it can be very confusing scrolling through a list of objects trying to finding recent changes. This is a bug.

    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  ·  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

  6. Fix bug with role members and schemas

    I filter out database users in my source control, because I do not want them accidentally deployed to another environment (may not be consistent across all environments). However, I do source control database roles, as many required permission sets are maintained through these roles. However:

    1. Currently it is not possible to check in a database role without also adding the role membership. This should be a configurable option.
    2. When using SQL Compare to deploy from source control, each user that is a member of a source controlled database role shows up as a "Schema" not present in the target database
    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…)
    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

  7. git - mechanism for adding/commiting external files

    I have a single repository for a project that contains both database files and c# code. Currently, git support only allows me to commit database files, leaving the c sharp code out of step and potentially in an inconstant state.

    It would be great if sql source control had the option to stage and commit other changes in the repository (or allow me to generate files but not commit changes - similar to working directory mode).

    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…)
    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

  8. I would like to see a command line interface added to the SQL Source Control. Having this to be able to automate saving change into TFS

    Have asked for this from support several years ago when the Source Control first was offered. Surprised still no command line interface. The ability to automate saving db changes automatically into TFS or GIT would be widely accepted by the DBA community. I would purchase it tomorrow if was made available.

    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…)
    1 comment  ·  Support Additional Source Control Systems  ·  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. Find revision number of deployed database

    It would be very useful if it was possible to see which revision number was last deployed to a database. Source Control 4 used to update the extended properties after deployment but version 5 no longer does this.

    Not knowing the revision number makes it difficult to bring a Live db up to the same revision as a UAT db, and ensuring the required migration scripts also get executed on the Live db.

    Any change this could be added somewhere? Extended properties seemed a good place to save it.

    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…)
    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

  10. SQL Toolbelt Installation/Product Manager - Control Panel

    It would be great if we could have a product manager for SQL Toolbelt and or individual products we're licensed for. In the manager you could see which products you have access to, which ones that are installed, view the VS and SSMS versions installed in your local system and install/uninstall products to the VS and SSMS versions. This would be similar in operation to the Telerik Control Panel which provides this kind of functionality.

    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  ·  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

  11. Option to skip migration scripts on a get latest

    If a migration script has already been run (to rename a table), we don't need to run it again. SQL Source Control is frequently crashing trying to deploy migration scripts and we don't have a way to skip them.

    Can we have a option to skip a migration script when getting latest?

    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  ·  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. Please Create Pull Request feature to SQL Source Control

    Please add the ability to create Pull Requests directly from SQL Source Control. In our environment, we require that any push to even the develop branch from a feature or bug branch requires a pull request.

    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  ·  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. Migrations Support for PlasticSCM

    I'd like to see migration scripts support for PlasticSCM. Why isn't something that is written as a "plugin"? Plastic isn't supported out of the box, but it's a simple enough matter to make a config file for it. Why can't the same be done for migrations? Allow the end user to create a config file (perhaps requiring the use of regular expressions for history parsing) or some other such mechanism. It seems like this should be a relatively straightforward thing to be able to do (it would also allow the customers to create the support for any SCM system they…

    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…)
    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
    started  ·  Elizabeth Ayer responded

    Hello! We believe that this now works if you’re connecting to PlasticSCM with the working folder option in SQL Source Control. Before we close this request, though, we’re hoping that one of you with a real installation can check it out and let us know.

    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!

  14. Square brackets

    Please add an option to script the database objects with square brackets around the object names. The Microsoft Management Studio Scripts include Brackets around the object names when they are scripted. So, if an objects is scripted from SSMS then run against the database it show up as being different in Source Control because the brackets were included in the SSMS script. Of course, you can manually remove the brackets before running the script but this will be cumbersome. I know that using the file that has been checked into SVN is another work around but we all know that…

    8 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

  15. BUG? "Changes to commit" icon, however, there are no changes

    We have some databases that get hammered overnight, tables are created, dropped so on (don’t ask, 3rd party databases = fail). Anyways, by the following day the database is back to its original state (schema wise). The databases have a "changes to commit" icon, however, when i right click and select "commit changes to source control..." it never finds anything different and i get "No objects with changes to be committed to source control".

    This is repeatable and happens most mornings.

    8 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

  16. Fortress - Exclusive Checkout / Object - Lock

    Similar to how fortress works with visual studio. All objects in the database would require an exclusive or shared lock to be worked. If an object is changed without a lock it becomes renegade for that user.

    8 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  ·  Better Support for Shared Db Dev Model  ·  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

  17. Selectable database in the source control window

    Could there be a way to choose which database the source control system is looking at, other than the 'last' database selected in the object explorer frame?

    We have several databases on our server, and we cannot explore them/switch between them in the object explorer frame whilst attempting to do something in the SQL Source Control window as it changes the database, and so stops its current action (generally a slow refresh), which is getting rather annoying...

    8 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…)
    6 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

  18. Warn when Get Latest cause data loss

    If a table or column is dropped in svn, e.g. due to a merge from one branch to another, then Get Latest will happily do this without notice. Any data loss caused by Get Latest should at the very least cause a warning.

    8 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

  19. Is there any planned support for SVN bugtraq properties?

    Is there any planned support for SVN bugtraq properties?

    Right now it seems to ignore any of those settings.

    For example,

    bugtraq:label
    bugtraq:message
    bugtraq:number
    bugtraq:url
    bugtraq:warnifnoissue

    8 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

  20. disabled triggers not detected or commited as disabled

    When disabling a trigger, it is not detected as a change to check in

    8 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
1 2 … 8 10 12 … 29 30
  • Don't see your idea?