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. Only certain users database should be able to do source control

    I had three different connection in SSMS. One for each user: Sql admin, webadmin, webapplication user. I think I by mistake made a commit from the connection for the webapplication user which have very few rights. All the users right got screwed up after that.

    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  ·  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. Default constraint names with escape characters aren't registered as a change

    I accidently did an sprename 'DFVisitsSome3234234', '[DFVisits_SomeNumber]', 'Object' and committed it to SVN. Now, when I change it back, the Source Control does not detect this as a change to commit back. How do I get around this, or it's a bug.

    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  ·  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. 1) Source Control - Get latest: first schema's then udf's and xsd schema THEN the rest

    1) Source Control - Get latest: first schema's then udf's and xsd schema THEN the rest

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

  4. Do changes have to be applied in order?

    SQL Source Control increments a Revision number after each change. Does this imply that I am required to apply all changes up to a given Revision in a second database? I really want to apply only selected changes, and in my own order.

    RELATED: If I select Revision 10 to apply to my database, and then select Revision 7, have I effectively removed changes for Revision 8, 9 and 10?

    Note that I am most concerned about DATA in these cases. The schema for this particular project is mostly stable. I'm just trying to keep track of data rows that…

    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  ·  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. It says No database selected - select a database in object explorer. I do have a database selected in object explorer. How do I get started?

    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  ·  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. Do Not Allow HG Commit without a FogBugz BugID/CaseID

    Currently with Tortoise Hg we can prevent a commit if the commit message does not contain a FogBugz bug/case ID. Based on a conversation with Red Gate support, SQL Source Control commit does not currently support this functionality. Please add it ASAP.

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

  7. Multiple comments per commit

    We are using a web hosted repository that is very slow. It would be good if we could make comments for multiple items being committed. i.e. proc 1 with comment 1, proc 2 with comment 2 etc.

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

  8. The database name used by Source Control is missing in the SQL Source Control screen

    So I don't know which db SQL Source Control is using, which is annoying. SQL Source Control version is 3.0.13.4214.

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

  9. Add searchable 'tag' values to be associated with Source Control check-in.

    Such tags might include task/issue tracking numbers, Agile cycle, or other relevant information. Such a feature would allow for the correlation of management of activities beyond the RedGate tool.

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

  10. Sql Source control is saving permissions for users that I don't care about

    I only save certain users (app users, etc.) to source control on my linked dev database. I am not concerned about other users' object permissions. There needs to be a way to ignore them. I know you can via Schema Compare, but the ignore option needs to be in Sql Source Control.

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

  11. Bug. The Change Connection functionality within the SQL Editor is disabled by SQL Source Control.

    When my connection is disabled in SSMS, I use the Change Connection functionality to reestablish it. With SQL Source Control installed, I can't because the Change Connection functionality is disabled.

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

  12. How big of a table can the Link Data source control support?

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

  13. Bug with certain tables names

    If you have 2 tables Config and ConfigData and wish to store static data for both of them then after you have committed successfully it comes back saying that that the Config is not committed and lets you commit it again. Each time incrementing the committed version but always saying there is a difference. It is most liely because you store the data scripts as <tablename>_data.sql and it is getting confused between the 2 tables.

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

  14. UI defefect after unlinking SQL DB from VCS

    DB was linked to SVN repository.
    I needed to move its location (apparently not supported).
    So I unlinked, planning to re-link in new location, disregarding history.
    Once unlinked, the source control tab UI was messed up.
    Close the tab, re-open, still messed up.
    Disconnect the DB, reconnect, show the source control tab, still messed up.
    Close SQL Management studio, restart, show DB, show source control tab, then finally it was OK again.

    Messed up = I could not see the any of the text on the setup tab that normally says "not linked... Link DB to source control..."
    In its…

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

  15. Every database has its own Comments before Commit

    I usually use the Comments feature of the Source Control in two ways:
    1. The normal way, i.e. as the comment for a Commit
    2. A note before "Commit". But, using it as a note is quite awkward because it will not stick with the database. When moving to another database, the note will become the note for current database.
    I wish that the every database can have its own Comment to stick with before Commit so that it will not accidentally commit with the wrong comments.

    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

  16. Non breaking space in stored procedure causes error on check-in

    I've been experiencing errors on check-in for a stored procedure that was OK as far as SQL Server was concerned. Source Control was complaining about syntax errors all over the procedure. The problem was that the proc was copied from a web page and all the spaces were non-breaking spaces. After replacing them with "normal" spaces the check-in was fine.

    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

  17. Linked data rollback does not filter table(s) when using Sql Data Compare

    A developer changed a value on some static reference data. I right-clicked on the table to show the source control history. Then I selected the latest changeset to overwrite changes made to the database. This task uses Data Compare. However, when the tool comes up, all of the tables are selected instead of the one that I selected. I wanted Sql Source Control to filter just the table that I selected or at least filter the tables associated with a targeted changeset.

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

  18. BUG: User Defined Table Types with Defaults show as different when they are not.

    All of our User Defined Table Types with declared Defaults show up as different and needing to be committed when there are no differences. Then during the commit process it shows an error saying "Nothing to commit"

    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  ·  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. Very frequent disk activity

    When I have SSMS open with a DB linked to TFS I hear a burst of disk activity every 4 seconds. It's driving me to distraction. What can I do, other than unlike the DB whenever I'm not actually doing an update?

    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  ·  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. Still having to manually apply indexes to tempdb to prevent timeouts

    I had to apply this index to tempdb (created by my missing index script).

    CREATE INDEX [missingindex2019RG_AllObjects] ON [tempdb].[dbo].[RG_AllObjects] ([Expired]) INCLUDE ([DatabaseID], [ObjectType], [ObjectID])

    This is a work-around until the DB service gets re-started and then I have to re-execute the statement because tempdb gets re-built.

    Also, there is no way that I know of to disable Sql Prompt which was blocking the create index statement. The only way I got the index applied was to hop to another computer without Sql Prompt.

    Index management in tempdb needs to be managed better.

    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  ·  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
1 2 … 24 26 28 29 30
  • Don't see your idea?