we have 13000 objects in our database.
12800 of them are all in the dbo schema which contains the standard logic for our product.
The rest 200 are in the customer specific schema.
We are not interested in source controlling the standard logic, since we get it from our supplier.
We need to source control our customer specific changes. For that every change is made in another schema.
We can perfectly filter the objects out for source control with your tool.
(so they do not appear on the commit screen). However it is very very slow, that's why I suspected the tool not to filter the objects "server-side"

I started a profler session and my suspicion was confirmed: the tool is getting all objects and then filters the rows "client-side".
So first getting 13000 objects to not use 12800 of them. It is also using a lot of memory (after 2 hours we get memory exceptions).
Could you please change this? Now I'm trying to convince the team to use those tools (I used them on smaller projects).
But with this speed, they won't agree.
Here the queries I catched when opening commit tab with filter on:

SELECT so.name AS TableName,
ss.name AS TableOwner,
cc.name AS ConstraintName,
cc.object_id AS Constraint_id,
cc.is_not_for_replication AS NotForReplication,
cc.is_not_trusted AS WithNoCheck,
cc.is_disabled AS Disabled,
sc.name AS ColumnName,
cc.parent_column_id AS colid,
cc.definition AS Text,
CONVERT(bit, CASE cc.is_system_named WHEN 1 THEN 1 ELSE 0 END) As is_system_named
FROM sys.check_constraints cc WITH (NOLOCK)
INNER JOIN sys.objects so WITH (NOLOCK) ON so.object_id=cc.parent_object_id
LEFT JOIN sys.schemas ss WITH (NOLOCK) ON ss.schema_id=so.schema_id
LEFT JOIN sys.columns sc WITH (NOLOCK) ON sc.column_id=cc.parent_column_id AND sc.object_id=cc.parent_object_id
ORDER BY so.name, cc.name

SELECT s.name AS ProcedureName,
p.name AS ProcedureOwner,
ss.name AS SchemaName,
s.object_id AS id,
CONVERT(bit, ISNULL(sm.is_schema_bound,0)) AS SchemaBound,
CONVERT(bit, ISNULL(sm.uses_ansi_nulls, 0)) AS AnsiNulls,
CONVERT(bit, ISNULL(sm.uses_quoted_identifier,0)) AS QuotedIdentifier,
s.type AS ProcedureType,
am.assembly_class,
am.assembly_method,
CASE WHEN am.null_on_null_input IS NULL THEN sm.null_on_null_input ELSE am.null_on_null_input END AS null_on_null_input,
COALESCE(p2.name,p3.name) AS execute_as,
CONVERT(bit, COALESCE(
CASE WHEN am.execute_as_principal_id = -2 THEN 1 ELSE 0 END,
CASE WHEN sm.execute_as_principal_id = -2 THEN 1 ELSE 0 END)) AS execute_as_owner,
a.name AS assembly,
case when sm.definition is null THEN CONVERT(bit, 1) else CONVERT(bit, 0) END AS encrypted

FROM sys.objects s WITH (NOLOCK)
LEFT JOIN sys.database_principals p WITH (NOLOCK) ON p.principal_id=s.principal_id
LEFT JOIN sys.schemas ss WITH (NOLOCK) ON ss.schema_id=s.schema_id
LEFT JOIN sys.sql_modules sm WITH (NOLOCK) ON sm.object_id=s.object_id
LEFT JOIN sys.assembly_modules am WITH (NOLOCK) ON am.object_id=s.object_id
LEFT JOIN sys.assemblies a WITH (NOLOCK) ON a.assembly_id=am.assembly_id
LEFT JOIN sys.database_principals p2 WITH (NOLOCK) ON p2.principal_id=am.execute_as_principal_id
LEFT JOIN sys.database_principals p3 WITH (NOLOCK) ON p3.principal_id=sm.execute_as_principal_id
WHERE s.type IN (N'P', N'PC') AND
(CAST(CASE WHEN s.is_ms_shipped = 1 then 1
WHEN (SELECT major_id FROM sys.extended_properties WHERE
major_id = s.object_id AND minor_id = 0 AND class = 1 AND
name = N'microsoft_database_tools_support') IS NOT NULL THEN 1
ELSE 0
END AS bit)=0)

I am working on a project that is an enhancement to an existing database that is controlled by an external party. I am referencing objects that I have no control over via foreign keys, presently I cannot commit the foreign keys to source control unless I also commit the dependent objects. I do not want to commit these as I do not control them.

Would it be possible to have some mechanism that permits me to commit my changes without the dependencies, something like an override checkbox for the default behavior that will also place messages in the notification box when committing much like the ones where objects are created on different file groups.

One of my colleagues has colour blindness.

The distinction between a non-reviewed database (the grey circle) and a database with outstanding changes (blue / white icon) is difficult to see because of the fact that the icons are so small (the less pixels to compare, the harder it is by all accounts) and often can be far away (i.e. if there are other non-source controlled database between them on the database tree in SSMS).

It would be helpful to make a clear distinction between the icons - either make the grey icon a flat colour (i.e. remove the highlight within it) or to slightly change the shape of one the icons.

Everytime I try to Get Latest I get the following....

System.Exception: Failed to update to the head revision after 10 attempts ---> System.Exception: Failed to update to the head revision after 10 attempts
at RedGate.SQLSourceControl.Engine.LinkedDatabase.GetDatabaseFolderWorkspaces(ICancellableOperationStatus status, IScriptFolderStructure scriptFolderStructure, IReadOnlySourceControlServerCallBacks callBacks, SourceControlRevision& revision)
at #GWeb.#WXM.#Fieb()
at #GWeb.#Wheb.#tieb(Func`1 )
at #GWeb.#WXM.#8ZW(Boolean )
at #GWeb.#XXM.#yRW()
at #GWeb.#WXM.#qYM()
at #GWeb.#XXM.#iS()
at #qlhb.#0heb.#l36(String , #1heb , ICancellableOperationStatus )
at #qlhb.#K3c.#83c(String , #O9U , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#A3.#eL5b(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#jzb.#Qnw()
--- End of inner exception stack trace ---
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#VAb.#xSXc()
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#uz2b(String , IDatabaseConnection , #1heb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action )
at #qlhb.#0heb.#wieb(IBoundDatabase , ICompareOptions , Boolean , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action )
at #GWeb.#VXM.#mYM[#NrPb](IBoundDatabase , Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
at #GWeb.#VXM.#kYM(IBoundDatabase , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#8Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#izb.#SB7b(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke()
at #eEc.#Qlg.Invoke()
at #JLc.#PLc.#Jfb.#EJf()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean )
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 , Object )