Synchronization Strategies

Strategy Matrix

Synchronization Strategy Reference

Strategy	When	Notes
Full metadata sync	Initial / drift	spMFSynchronizeMetadata
Class-focused sync	New classes only	spMFSynchronizeClasses
Property delta sync	Added properties	spMFSynchronizeProperties
Scoped metadata slice	Value lists, etc.	spMFSynchronizeSpecificMetadata
Object type isolation	Narrow ingestion	spMFSynchronizeObjectType

Selective Metadata Slices

Use spMFSynchronizeSpecificMetadata to reduce load when only value lists or workflows changed.

Example:

EXEC dbo.spMFSynchronizeSpecificMetadata
     @SyncScope = N'Workflows';

Idempotency & Drift

Routines are idempotent—re-running after no change should be fast. Investigate drift if column counts or property alias sets diverge unexpectedly.

Process Logging

Each synchronization can (optionally) attach to a ProcessBatch. See: spMFProcessBatch_Upsert.

Validation Queries

SELECT ClassTableName, PropertyCount = COUNT(*)
FROM dbo.MFClassProperty
GROUP BY ClassTableName
ORDER BY PropertyCount DESC;