588 results found

1. This app to too chatty with the database! Turning polling off is not straightfoward to do like it should be and once you start Source Contro

   Turning off polling is not a straightforward task. And after I've used Source Control I have to exit SSMS and restart it in order to not have it generate a ridiculous about of traffic to my SQL Server 2012 SP1 instance. This has to be fixed or I'll find another tool.

   8 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  ·  History/Log  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. SQL Source Control 3.1.0.5208 Failed to commit changes

   System.IndexOutOfRangeException: UserName
   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at System.Data.SqlClient.SqlDataReader.get_Item(String name)
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc(IEnumerable1 , SqlCommand )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection1 , SqlDateTime )
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName)
at #mlhb.#ny2b.#jiUc()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func1 func)
   at #GWeb.#WXM.#P6Uc(Func1 )
at #mlhb.#ny2b.#xFV()
at #mlhb.#ny2b.#aQU(ICollection1 #vfX, DatabaseObjectIdDictionary1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
at #mlhb.#ry2b.#zYM(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
at #GWeb.#VXM.#mYM[#NrPb](Func2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
   at #GWeb.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
   at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
   at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus )
   at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation1.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation1.Invoke()
   at #eEc.#Qlg.Invoke()
   at #JLc.#PLc.#Jfb.#EJf()
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate1 , Boolean )
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation1 , Object )

   System.IndexOutOfRangeException: UserName
   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at System.Data.SqlClient.SqlDataReader.get_Item(String name)
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc(IEnumerable1 , SqlCommand )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection1 , SqlDateTime )
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName)
at #mlhb.#ny2b.#jiUc()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func1 func)
   at #GWeb.#WXM.#P6Uc(Func1 )
at #mlhb.#ny2b.#xFV()
at #mlhb.#ny2b.#aQU(ICollection1 #vfX, DatabaseObjectIdDictionary1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
at #mlhb.#ry2b.#zYM(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
at #GWeb.#VXM.#mYM[#NrPb](Func2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
   at #GWeb.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
   at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
   at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus )
   at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation… more

   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…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. BUG(?): Rebuilding a table via migration script doesn't add the correct authorization commands

   When rebuilding a table via migration scripts, the ALTER AUTHORIZATION TO... commands are omitted on the replacement table when the migration script is created by SSC.

   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  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Rife with Out of Memory Exceptions.

   So, I install the tool to use with a real-world database of 1GB. And all I get are Out-of-Memory exceptions when trying to add data. Or even just run the tool. This is one of the worst software experiences that I've ever had!

   Did I just get a buggy version? 3.0.13.4214

   12 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…)
   5 comments  ·  Initial Setup  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. SQL Source Control / Red Gate Configuration Database

   I think it would be nice if SQL Source Control (or Red Gate in general, in case it is useful across other products) had its own config database. This would be the one location to store all information related to this product, instead of storing some information in a database (v3.1 RG_AllObjects table), some in .xml config files, and some as extended properties on the database.

   I would much rather create one database (that I could specify on install, instead of having to go into a config file and change it from TempDB) that I could host of a single instance of SQL Server and point SQL Source Control at it from any instance and any workstation I am using the product on.

   I would hope this would also include a gui to make any changes, as it is more difficult than necessary right now to change things like polling interval and the logging database location. This should all be via a gui instead of having to manually go into config files. And it should all be able to be referenced from multiple machines, instead of having to configure these things on every coworkers workstation.

   I think it would be nice if SQL Source Control (or Red Gate in general, in case it is useful across other products) had its own config database. This would be the one location to store all information related to this product, instead of storing some information in a database (v3.1 RG_AllObjects table), some in .xml config files, and some as extended properties on the database.

   I would much rather create one database (that I could specify on install, instead of having to go into a config file and change it from TempDB) that I could host of a single… more

   15 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  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. accurev

   I'm missing native support for AccuRev (http://www.accurev.com/) in the SQL Source Control product.

   18 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  ·  Support Additional Source Control Systems  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. ComparisonOptions.xml should be easily shared and checked-in for each project

   Having to set up as described in the link below isn't very nice at all.
   http://documentation.red-gate.com/display/SOC3/Setting+SQL+Compare+options+in+SQL+Source+Control

   This should be a standard (easily-accessible) setting that you can have on a per-project basis (not a per developer basis) so that you don't have to worry about individual machines.

   17 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  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. 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 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 →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. compare what I am about to check in against the previous check in

   I see the changes to be checked in , these may have been done by other developers. I want to compare the changes about to be checked in against the previous version to see what changed before I check in.

   7 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  ·  Better Support for Shared Db Dev Model  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. 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 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. History window shouldn't prevent access to main window

    While viewing the history log you can't go to the main SSMS window. This is an issue if you want to look at source code history side by side with another window.

    16 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  ·  History/Log  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. 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 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  ·  Better Support for Shared Db Dev Model  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. 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 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. Link source control to Schema, not database

    We couple applications with schemas, not databases. It would be great to link source control to just one schema, rather than the entire database. This way, we can source the code for the application and the database in the same branch

    10 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  ·  Better Support for Shared Db Dev Model  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. BUG in Commit Changes with a calculated xml column.

    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 SQLLatin1GeneralCP1CIAS NULL,
    [StandaardTitularis] [varchar] (40) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAccount] [xml] (CONTENT [dbo].[UschBasisgegevensPersoneelFinancieleRekeningDetailsAccount]) NULL,
    [StandaardPostkode] [varchar] (4) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardLokaliteit] [varchar] (36) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardCountryCode] [char] (2) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAddressLine1StraatNummer] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAddressLine2PostNummerStad] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeBegunstigdeInformatie] [varchar] (1) COLLATE SQLLatin1GeneralCP1CIAS NOT NULL,
    [AfwijkendeBankrekeningnummer] [varchar] (14) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeTitularis] [varchar] (40) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeAccount] [xml] (CONTENT [dbo].[UschBasisgegevensPersoneelFinancieleRekeningDetailsAccount]) NULL,
    [AfwijkendePostkode] [varchar] (4) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeLokaliteit] [varchar] (36) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeCountryCode] [char] (2) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeAddressLine1StraatNummer] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [AfwijkendeAddressLine2PostNummerStad] [varchar] (70) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [Bankrekeningnummer] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardBankrekeningnummer] else [AfwijkendeBankrekeningnummer] end),
    [Titularis] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardTitularis] else [AfwijkendeTitularis] end),
    [Account] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardAccount] else [AfwijkendeAccount] end),
    [Postkode] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardPostkode] else [AfwijkendePostkode] end),
    [Lokaliteit] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardLokaliteit] else [AfwijkendeLokaliteit] end),
    [CountryCode] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardCountryCode] else [AfwijkendeCountryCode] end),
    [AddressLine1StraatNummer] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardAddressLine1StraatNummer] else [AfwijkendeAddressLine1StraatNummer] end),
    [AddressLine2PostNummerStad] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [StandaardAddressLine2PostNummerStad] else [AfwijkendeAddressLine2PostNummerStad] end),
    [AccountType] AS (case [AfwijkendeBegunstigdeInformatie] when 'N' then [dbo].[UFXMLBepaalAccount]([StandaardAccount]) else [dbo].[UFXMLBepaalAccount]([AfwijkendeAccount]) end)
    ) ON [PRIMARY] TEXTIMAGEON [PRIMARY]

    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 SQLLatin1GeneralCP1CIAS NULL,
    [StandaardTitularis] [varchar] (40) COLLATE SQLLatin1GeneralCP1CIAS NULL,
    [StandaardAccount] [xml] (CONTENT [dbo].[UschBasisgegevensPersoneelFinancieleRekeningDetailsAccount]) NULL,
    [StandaardPostkode] [varchar] (4) COLLATE SQLLatin1GeneralCP1CI… 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…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. 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 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 →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Can you see the author of a revision on the "Get Latest" tab?
    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…)
    0 comments  ·  Support Additional Source Control Systems  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminStephanie (Product Manager, Redgate) responded

    If you right click on the object, you can show history to see the author, when it was done, what was changed, and the author’s comment.

18. Add preemptive error checking

    Add preemptive error checking.
    One of our challenges is that it is too easy to break the get latest functionality. If a developer renames a column but doesn't rename all references (because he forgot to use Smart Rename) he is essentially breaking the database build. If I use Continues Integration to build the latest SQL changes, I have no bullet-proof way of ensuring that my database compiles at all time. I would like to ask Redgate to not allow a check-in which will break the build. I imagine that all that needs to be done is to ensure that first generation dependencies don't have errors. It would be nice if this is an option that can be turn on or off.

    Add preemptive error checking.
    One of our challenges is that it is too easy to break the get latest functionality. If a developer renames a column but doesn't rename all references (because he forgot to use Smart Rename) he is essentially breaking the database build. If I use Continues Integration to build the latest SQL changes, I have no bullet-proof way of ensuring that my database compiles at all time. I would like to ask Redgate to not allow a check-in which will break the build. I imagine that all that needs to be done is to ensure that first… more

    12 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  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. 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 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  ·  Static Data  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. 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 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  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close