ss_DeltaAll allows you to run ss_Delta in bulk.
Simple Example
exec ss_DeltaAll 'DEMO'
With @ObjectNameFrom
exec ss_DeltaAll 'DEMO', 'Opportunity'
This will commence the bulk ss_Delta replication from the Object immediately following Opportunity, which could be OpportunityCompetitor if there is no other custom or standard object with a name closer to Opportunity, sorting alphabetically. This is useful if a prior run of ss_DeltaAll has failed for whatever reason and you wish to re-commence from the point of failure.
With AutoReplica = Yes
exec ss_DeltaAll 'DEMO',null,’Yes’
@AutoReplica will be passed through to each attempted ss_Delta, which will automatically failover to ss_Replica should any AutoReplica condition be met.
Parameters
Parameter | Purpose |
@Env | SQL Sales Environment Name |
@ObjectNameFrom | This will commence the bulk ss_Delta replication from the Object immediately following the one passed in via @ObjectNameFrom. This is useful if a prior run of ss_DeltaAll has failed for whatever reason and you wish to re-commence from the point of failure. |
@AutoReplica | @AutoReplica will be passed through to each attempted ss_Delta, which will automatically failover to ss_Replica should any AutoReplica condition be met. |
ss_ObjectInclusion inclusion table
Field | Purpose |
ObjectName | Definition of Objects you wish to include in each ss_DeltaAll run. Only Objects contained in this table will be considered in scope. Accompanying table ss_ObjectExclusion will additionally be referenced, i.e. Objects within will be ignored. |
ss_ObjectInclusion exclusion table
Field | Purpose |
ObjectName | Add any Objects in this table to have them excluded from each ss_DeltaAll run. On deployment (ss_EnableDatabase) a number of known problem Objects are included in this table along with their API Response Error Msg and Codes, for general reference.
It is a matter of choice whether you specify an Inclusion set (via ss_ObjectInclusion) or exclude via this table. Generally, only a relatively small number of Salesforce objects are required to maintain a working replication database and hence ss_ObjectInclusion is more appropriate, or even a hard coded list of ss_Delta commands for each required Object, for example:
ss_Delta ‘DEMO’, ‘Account’ ss_Delta ‘DEMO’, ‘AccountHistory’ ss_Delta ‘DEMO’, ‘Opportunity’
Which is run via a SQL Agent Job or similar.
Running with no entries in this table but some entries in ss_ObjectExclusion would be more appropriate, if you wanted to automatically take an entire backup of your Salesforce Org, for example. |
ErrorMsg | Salesforce API Response Error Msg |
ErrorCode | Salesforce API Response Error code |