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

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

588 results found

  1. It would idea if you could see all linked server/databases within SQLSource Control and the version that they are running or at least the last version that they sync'd with

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  2. Working in a Team development, I do not want changes not to be commited to TFS. If I forget on closing, then a pop up window should ask you if you want to commit your changes.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. When right-clicking a database in the Object Explorer Details page. The context menu doesn't reflect the database you click on. It still relates to the database selected in the Object Explorer tree.

    SSMS 10.0.4000
    SSC 2.2.1.23

    Thanks
    Phil

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Ability to disable transactions when updating DB with latest changes.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  5. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Commit dependencies dialogue shows blue dot on objects even when those objects have no changes to commit. This seems incorrect.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. if computed column contains a 'hashbytes' function call, the hashbytes will be surrounded by [], like [hashbytes] which causes an error. this bug exists since version 1.1. why did fix that!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  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)
  8. Sql compare allows the bottom file comparison pane to open as a new window. This allows you to see the list of different objects in one window and the file differences in another window. This is a great feature for comparing files and should be included with scc as it is in sql compare.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  9. When creating the migration script if the developer goes through "cherry-picking" the commit(s) that they wish to include in the migration script. It appears that non-selected commits that are between the selected ones are being picked up.
    For example if the developer chooses commit 1 and 3 and skips 2 the objects in commit 2 are still showing in the migration script.

    I would like to point out that this appears to be a bug and not a feature request, but i am still using 3 votes...

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  10. When we hop back in our source control repository to an older release and "update" our database, occasionally there is new static data that is referenced by non-static entries in the database. We do not have cascading deletes enabled for various reasons outside of the developers control, but in this particular instance it causes errors when static data is removed from the database to revert to an older version. Would it be possible to have redgate check incoming foreign keys and generate all the necessary deletes to allow static data removal?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 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)
  11. The source control system keeps thinking a certain table wasn't committed, and marks it up as "changed" to be committed. Here's the table:

    -- Columns

    CREATE TABLE [dbo].[EvaluacionesCiclosEducativosGruposAcademicos]
    (
    [CicloEducativoId] [int] NOT NULL,
    [EvaluacionId] [int] NOT NULL,
    [Grupo] [int] NOT NULL,
    [ProfesorId] [int] NOT NULL,
    [CursoId] [int] NOT NULL
    ) ON [PRIMARY]
    GO

    It doesn't seem to detect this line, and decides it has to insert it again:

    DISABLE TRIGGER [dbo].[tD_EvaluacionesCicloEducativosGruposAcademicos] ON [dbo].[EvaluacionesCiclosEducativosGruposAcademicos]
    GO

    At the time of this writing, it has inserted the very same section 4 times, one after the other, and wants to keep doing it.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Spell check on the comment text box would be helpful. Once a comment is checked into mercurial it is hard to fix the misspelled comments.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  13. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. SQL Source Control and SQL Compare should be able handle cross database dependencies in the same instance and should be able to generate a single migration script for both databases

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  15. When you have a table with a calculated xml column and you commit changes then the table stays changed as edit.
    example
    CREATE TABLE [dbo].[UtblLoonmotorMotorRechtzettingenHistoriekRechtzettingOverschrijvingen]
    (
    [BetalingsOpdrachtGuid] [uniqueidentifier] NOT NULL CONSTRAINT [DFUtblLoonmotorMotorRechtzettingenHistoriekOverschrijvingenBetalingsOpdrachtGuid] DEFAULT (newid()),
    [RechtzettingsGuid] [uniqueidentifier] NOT NULL,
    [BetalingsopdrachtenbestandGuid] [uniqueidentifier] NULL,
    [FinancieleRekeningGuid] [uniqueidentifier] NULL,
    [Bedrag] [numeric] (10, 2) NOT NULL,
    [Mededeling] [varchar] (100) COLLATE SQLLatin1GeneralCP1CIAS NOT NULL,
    [StandaardBankrekeningnummer] [varchar] (14) COLLATE SQL
    Latin1GeneralCP1CIAS NULL,
    [StandaardTitularis] [varchar] (40) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAccount] [xml] (CONTENT [dbo].[UschBasisgegevensPersoneelFinancieleRekeningDetailsAccount]) NULL,
    [StandaardPostkode] [varchar] (4) COLLATE SQL
    Latin1GeneralCP1CI

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  16. Shared mode is perfect for small team DEV environment, but status update delayed to sync is annoying....is there a way to config the sync frequency?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. When resizing SSMS, the SQL Source Control window does not resize correctly. Some UI elements appear on top of others. Not a major issue but is likely not working as expected.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  18. Make a function where you could setup a before/after Commit and before/after Get stored procedure which will be executed automatically.

    In my case I backup the Database diagrams to table with a stored procedure. I would like to run it before every commit. The restore sp could be run after a get

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  19. Normally, I can use RedGate's analysis of what SHOULD be retrievable from source control, or what SHOULD be commitable.

    Under certain circumstances, however, I know better than the tool does. For example, I might want to roll back a set of routines and/or tables to what is in revision control.

    Currently, I have to "jump through hoops" to do this. I have to do multiple steps, some of them crazy ones such as using "undo" counterintuitively (for instance, undoing a "drop" to actually get something that is missing).

    ** Can you give us a screen or a button or selector…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  20. The last update (current version: 3.4.8.18) introduced a bug that SQL Source Control had some time before: timeouts during checkin! :-( In addition, there are several processes "Red Gate Software - SQL Tools" that all produce massive CPUTime and DiskIO, slowing the whole development environment down. :-( When will a fix be available?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  • Don't see your idea?