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

Can you segment the data in procedures such as refresh all?

For example only pull records with a certain Country value or is it limited to just what tables you pull down.
1 person has
this question
+1
Reply
  • SF_Refresh and SF_RefreshAll are built to copy entire tables locally. If you want to be more selective, just use the linked server and pull the records you want:

    Select * into Account_Subset from SALESFORCE...Account where CountryCode__c = 'USA' and LastModifiedDate > '2015-12'-01'

    It is possbile to have SF_RefreshAll skip tables. Details are in the code of the proc. If you find yourself skipping tons of tables, then it is best to just use individual sf_refresh for the tables you want.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated