Mirroring All Salesforce Objects


Mirroring All Salesforce Objects


You can use the SF_MirrorAll stored procedure to mirror all your Salesforce objects (including custom objects). SF_MirrorAll compiles a list of all existing Salesforce objects and calls the SF_Mirror stored procedure for each object.

Salesforce objects that cannot be queried via the Salesforce API with no WHERE clause (like ActivityHistory) are not included. In addition, SF_MirrorAll skips Chatter Feed objects because of the excessive API calls required to download those objects. You can modify the stored procedures to include them if needed.

NOTE: SF_MirrorAll assumes that there are no foreign keys defined on the current set of local tables.

Running SF_MirrorAll to Mirror All Objects

To run SF_MirrorAll use the following commands in Query Analyzer:

 Use "Salesforce backups"
 EXEC SF_MirrorAll '𝘚𝘈𝘓𝘌𝘚𝘍𝘖𝘙𝘊𝘌_𝘓𝘚'

where SALESFORCE_LS is the name of your linked server.