179 results found

1. Problem with expiration

   This release of Red Gate SQL Source control...has expired. I tried to download a newer version but I am getting the same message.

   Please help me out...I would like to test your product.

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   If you need a trial extension, please contact sales@red-gate.com.

2. Revert/Undo Pending Change

   I started making changes to a db object, but I made a mistake and I want to start again. I should be able to revert or undo this pending change so that I'm back in the state I was before making these changes.

   22 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   Revert is included in v0.3.0.1. Right click on the database or an object in the Object Explorer and select “Other SQL Source Control Tasks > Revert (undo) changes…”

3. Support for Source Gear Fortress (Vault Professional Edition)

   We moved source control to a product by Source Gear called Fortress. Great Source Control. I would like Red Gate to support this.

   11 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Support Additional Source Control Systems  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   New EA version 2.0.3, which supports Vault and Vault Pro (5.x versions) is now available with static data and shared model support.

   Please visit the following link to download it:

   https://www.surveymk.com/s/SqlSourceControl_EapSignup

4. The URI needs to be an empty directory

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Delete…  ·  Admin →

5. SVN - Show Log (TFS - View History)

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   12 comments  ·  History/Log  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   Show history is now available as of v1.1.0.19. Please use Help > Check for Updates on the SQL Source Control tab within SSMS to make sure you have the latest version.

   Thank you!

6. Question about Trace query being run

   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 fntrace_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 ::fntracegettable(@defaultTraceFileName, default) AS dt
   LEFT JOIN sys.tracesubclassvalues AS sysTSV
   ON sysTSV.traceeventid = dt.EventClass
   AND sysTSV.subclassvalue = dt.ObjectType
   WHERE dt.EventSubClass IN ( 0, 1 )
   AND dt.EventClass IN ( 46, 47, 164 )
   AND sysTSV.subclass_name IN ('ST', 'AS', 'BN', 'CT', 'EN', 'IX', 'MT', 'PF', 'PS', 'RT', 'SC', 'SV', 'SX', 'TA', 'TR', 'U' );

   This was part of a lot more convoluted and overly complex query that was captured while profiling a server that I'm testing SQL Source Control on.

   The resultset from this query generated over 30K rows and only a very few related to the database that was under source control.

   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 fntrace_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 ::fntracegettable(@defaultTraceFileName, default) AS dt
   LEFT JOIN sys.tracesubclassvalues AS sysTSV
   ON sysTSV.traceeventid = dt.EventClass
   AND sysTSV.subclassvalue = dt.ObjectType
   WHERE dt.EventSubClass… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   I think the procedure has changed slightly, but it’s used to identify changes to your database to put blue indicators on your Object Explorer.

7. Overlay icons disappear in SSMS 2008 (10.0.2531.0) connected to SS2005

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   6 comments  ·  Delete…  ·  Admin →
   completed  ·  Elizabeth Ayer responded

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

8. Drop object should not be drop from SVN

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   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.

9. Exclude objects from versioning (svn:ignore)

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   40 comments  ·  Delete…  ·  Admin →
   completed  ·  Chris Smith responded

   Object Filtering now appears in SQL Source Control version 2.2!

   For more information about the release, please see:

   http://www.red-gate.com/MessageBoard/viewtopic.php?t=13735

10. Problem syncing Service Broker items

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    This has been fixed in v1.0. If you are still esperiencing any issues, please contact support@red-gate.com.

    Thank you!

11. How to reject changes?

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    3 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    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.

12. Proxy server option

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    Unfortunately, this cannot be configured at this time, but if sending fails, you can save the report to your computer and then email it to Support@red-gate.com.

    Thank you!

13. Support Multiple instances of SSMS

    It would be really handy to support mulitple instances of SSMS, especially for multi-monitor people.

    173 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    33 comments  ·  Delete…  ·  Admin →
    completed  ·  Jonathan Hickford responded

    Yesterday we released SQL Source Control 3.5, which includes support for multiple SSMS instances. Thank you to everyone who tested the beta.

    Please check for updates to install. Full release notes on http://documentation.red-gate.com/display/SOC3/SQL+Source+Control+3.5+release+notes

14. 0.2.1.1 Hangs SSMS 2008

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    This has been fixed in v1.0.

15. Source Control Data (Data folder is blank)

    would be awesome if it scripted the data as well

    250 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    20 comments  ·  Static Data  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    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.

16. Support merge / branch

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    20 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    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

17. Allow me to filter the objects on the commit/get latest tabs

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    13 comments  ·  Delete…  ·  Admin →
    completed  ·  Chris Smith responded

    Object Filtering appears in SQL Source Control from version 2.2.

    For more information, please visit:
    http://www.red-gate.com/products/sql-development/sql-source-control/features

    We’d love to hear from you if the object filtering feature does not satisfy your request – please add a comment.

18. Dedicated DB VS Shared (Centralized) DB Model

    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 said that, Stephanie explained that though SQL Source Control was designed to work with the "dedicated" db focus, for a few good reasons, it is still possible to use it with the centralized model if you're careful.

    I believe in a perfect world, the centralized DB, once connected to a Source Control repository, would simply keep track of every change made to objects. In other words, if I altered a stored procedure and clicked execute, that change would be automatically recorded in my source control history, so later if I had to, I could right click on it, and revert to a previous version. To be honest, I wouldn't even need the "Commit" or "Get Latest Version" functionality, because the DB would always be in the "Latest Version" state, and every change would be committed automatically. Just my thoughts.

    Allen Berezovsky

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

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    6 comments  ·  Better Support for Shared Db Dev Model  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    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.

19. Many Conflicts in GetLatest and Commit tab pages

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    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!

20. The whole thing is dead sexy.

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    Thanks for your feedback! It’s great to hear! :-)
    I’m closing this suggestion so you can have your votes back…