Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Best approach to backup data, handle schema changes and preserve deleted records

I am trying to back up Salesforce data in SQL using DBAmp.. Any suggestions on how to go about Step 2 and 3

1- first step is taking the current snapshot of the Salesforce objects. SF_ReplicateAll satisfies the objective.

2- Next i would like to create a job that refresh the tables daily but does not drop the table. It should adds columns if there are new columns added to the Salesforce object schema. I would like to keep the column if the Salesforce column was deleted.

3-set the is-deleted field to true on the records that exists in the local SQL table but no longer exist in Salesforce (Deleted from Salesforce and probably even no longer in recycle bin)
1 person has
this question