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

177 results found

  1. While attempting to Create new link to source control in SSMS 2008 I receive the following message: "The URI needs to be an empty directory."
    How can I resolve this?

    Please advise..
    Brett

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Flag idea as inappropriate…  ·  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. Having an option to calculate/determine the synchronizing between source control and local objects can be triggered with a button action rather than automatically starting this process when the source control tab is in focus.

    317 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    41 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. To have a tab that would simply grab and display the Log/History would be invaluable. This would be a fairly simple addition I would think.

    71 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  History/Log  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Just wondered if someone could explain what the following query has to do with source code control in a Database.

    SET XACTABORT ON ;

    DECLARE @defaultTraceFileName NVARCHAR(256);

    SELECT @defaultTraceFileName = CONVERT(NVARCHAR(256), value)

    FROM fn
    trace_getinfo(DEFAULT)

    WHERE [property] = 2

    AND value IS NOT NULL;

    SELECT
    dt.StartTime
    , dt.DatabaseID
    , dt.TransactionID
    , dt.EventSubClass
    , dt.EventClass
    , dt.ObjectID
    , sysTSV.subclassname AS ObjectType
    , CONVERT(NVARCHAR(256), NULL) AS SchemaName
    , dt.ObjectName
    , dt.LoginName
    , dt.ApplicationName

    FROM ::fn
    tracegettable(@defaultTraceFileName, default) AS dt
    LEFT JOIN sys.trace
    subclassvalues AS sysTSV
    ON sysTSV.trace
    eventid = dt.EventClass
    AND sysTSV.subclass
    value = dt.ObjectType
    WHERE dt.EventSubClass…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  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. The overlay icons disappeared when I connected to a SQL Server 2005 database using SSMS 2008. This is the first time I've noticed this behavior.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Elizabeth Ayer responded

    Hi. We think that this is fixed. Please let us know if you’re still experiencing issues with the icons.

  6. If someone drop a object and commit it, we lost the object in SVN and the history of it.

    You need to found a workaround like Rename _DROP

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Dropped objects are no longer in the latest version in source control, but they are still in the previous versions. In SVN, if you “show log,” on the directory level, you should be able to find the dropped object. You can right-click on it and “show log” again to get the entire history for that dropped object.

  7. As it is possible to exclude some files from SVN using file source control it would be great to remove some objects that we do not want to version - for example test procedures or users.

    261 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    40 comments  ·  Flag idea as inappropriate…  ·  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. Have two service broker services that won't synchronise.

    Database version shows,
    CREATE SERVICE [//DBA/Login-Service]
    AUTHORIZATION [dbo]
    ON QUEUE [dbo].[Login-Queue]
    (
    [http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]
    )
    GO

    Source control version shows,
    CREATE SERVICE [//DBA/Login-Service]
    AUTHORIZATION [dbo]
    ON QUEUE [dbo].[Login-Queue]
    GO

    When I try and commit the changes, it stops at the "Sending Files ..." step and says "Nothing to commit"

    11 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  ·  Flag idea as inappropriate…  ·  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. Is it possibility to reject changes which has been made for object? I couldn't find such function. If there are not, there should be such possibility.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    If you haven’t commited your changes yet, then you can right-click on the object in the Object Explorer and select Other SQL Source Control Tasks > Undo. This will revert your change to your db so that you are back to the state you were in before you started making changes to the object.

    If you actually want to get back to a previous version, then please vote/comment at https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/492431-get-specific-version-from-source-control-svn-upd.

  10. My work has an internet proxy server that filters connections. When the reporting tool asked to send crash report it failed because proxy server wasn't specified. Any way to configure this?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  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. It would be really handy to support mulitple instances of SSMS, especially for multi-monitor people.

    173 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    33 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. SSMS 2008 hung after upgrading to 0.2.1.1. I had to kill the task. I started SSMS 2005, which opened normally. Then, I reopened SSMS 2008 and it started normally.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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. would be awesome if it scripted the data as well

    250 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    20 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    SQL Source Control v2.0 is now available with support for source controlling your static lookup data from within SSMS. For more details, see http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.

    If you’ve been using SQL Data Compare Pro to source control your data in the “Data” folder, then please contact support@red-gate.com to keep your history.

    If you need any advanced features, like only source controlling a subset of columns or limiting the rows with a WHERE clause, then you will need to continue to use SQL Data Compare Pro, http://www.red-gate.com/help/SourceControlData.html.

  14. I want to be able to work with more then one database, I want to have database for each developer that are all branches of the "trunk" db.

    156 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    20 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We now support branches from your source control system. You should be able to branch in your source control system and then link a database directly to that branch.

    Please contact support@red-gate.com if you have any problems or post a new suggestion for more specific features that you’d like us to implement around this, https://redgate.uservoice.com.

    Thank you!
    Stephanie M. Herr :-)
    SQL Source Control Product Manager

  15. Provide option to filtering based on type of objects just like sql compare and then select all or unselect all option. This will speed up the selection process.

    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Flag idea as inappropriate…  ·  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. I recentrly had a brief email exchange with Stephanie from Red Gate, where I explained that we use a centralized Development database, instead of every developer having a dedicated local version of the DB against which they develop. I believe that the Centralized Dev DB model is the model used most in the field, mainly for two reasons. 1) Most companies don't want their developers to have local copies of the database for security reasons, and 2) Development DBs often hold a lot of test data which would not be practical for all of the developers to have locally.

    Having…

    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)

    SQL Source Control supports either model, http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.

    v2.0 has the following enhancements for the shared model:
    If you setup your database as shared, then you will see who last updated each object on the Commit tab and Undo dialog. Only objects that you last updated will be checked by default. This will prevent you from accidentally committing/undoing others changes that work on the same db.

    We are also addressing the problem so that you will no longer see invalid conflicts on the Commit tab.

  17. I've created new link to some DB, then commint changes. Then... i've linked some other DB to prevously created link. Now i have many conflicts. For example:
    "create procedure dbo.proc1" a version in DB and "create procedure proc1" a version in source control. In my opinion by linking to existing DB in source control get lates step should be done. To equal both versions.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    If your database matches what is in source control, we now update your underlying working folder after you link a db so that you don’t see these conflicts on the Commit/Get tabs.

    Thank you!

  18. I'm looking forward to source control of data. It's very low impact, which are the only kinds of tools that get used when schedules get off track, which is to say, week three of any project.

    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  ·  Flag idea as inappropriate…  ·  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. Ran into an issue when entering a stored procedure with a semi colon in it.

    Failed to update:

    oEc.#8Jf: Errors occured whilst parsing file C:\Documents and Settings\Adam\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\4c857d86-7cf5-464b-86bc-01d4f22d1423\Stored Procedures\Article.GetArticlesByKewords.sql

    'line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]'
    ---> cZ: Errors occured whilst parsing file C:\Documents and Settings\Adam\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\4c857d86-7cf5-464b-86bc-01d4f22d1423\Stored Procedures\Article.GetArticlesByKewords.sql
    'line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]'
    ---> line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]
    --- End of inner exception stack trace ---
    at #oEc.#7Jf.#t.#B3.#sKf()
    at #oEc.#7Jf.#gKf(Action action)
    --- End of inner exception stack trace ---

    Server stack trace:
    at #eEc.#fEc.#t.#izb.#j5f()
    at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[]…

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  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. I had disconnected a DB from source control due to performance issues. I have a work-around supplied by RG tech support. When I tried to re-link, I got this message and I am unable to link to the DB in source control.

    Failed to update:

    oEc.#8Jf: Failed to locate the target table [dbo].[Transaction] for the FKTransactionDataTransaction foreign key. ---> RedGate.SQLCompare.Engine.SqlCompareException: Failed to locate the target table [dbo].[Transaction] for the FKTransactionDataTransaction foreign key. ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1435, offset:37 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1369, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  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?