586 results found
-
show migration scripts in the history window
History window should indicate the fact that some of the changes are covered by the migration scripts and provide the ability to view these scripts
10 votesWe have been working on v2 of Migrations, which stores migrations scripts in a table valued function within the database. This table valued function appears in the history. An Early Access Release of SQL Source Control is now available and can be downloaded from http://documentation.red-gate.com/display/MV2.
NOTE: This is an Early Access Release and is not fully tested or functionally complete yet. It would be great if you could try it in a test environment and let us know about your experiences so we can fix any issues and try to make any updates you need before the full release.
Thank you!
Stephanie Herr :-)
SQL Source Control Product Manager -
Use windows username instead of disaply name for linking to TFS 2012
I am unable to link databases to TFS 2012 due to our parent company enforcing a Active Directory display name of "LastName, FirstName" which TFS claims is invalid due to the comma.
It is a known issue with TFS (http://connect.microsoft.com/VisualStudio/feedback/details/768112/tfs-2012-build-failing-with-tf10158-user-name-contains-unsupported-characters)
The workaround listed on Microsoft Connect is to use "domain\username" instead of display name when sending commands to TFS. Unfortunately, SQL Source Control doesn't expose a way to do this currently.
8 votes -
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 -
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 )1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection1 , SqlDateTime )1 func)
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName)
at #mlhb.#ny2b.#jiUc()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func
at #GWeb.#WXM.#P6Uc(Func1 )1 #vfX, DatabaseObjectIdDictionary
at #mlhb.#ny2b.#xFV()
at #mlhb.#ny2b.#aQU(ICollection1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
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](Func
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…4 votes -
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 -
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 -
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…
15 votes -
accurev
I'm missing native support for AccuRev (http://www.accurev.com/) in the SQL Source Control product.
18 votes -
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+ControlThis 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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 SQLLatin1GeneralCP1CI…3 votes -
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 -
4 votes
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.
-
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…12 votes
- Don't see your idea?