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

Replication exclusion list ?

I can see SF_ReplicateAll is trying to skip tables that cannot be replicated for some reason. In my case I have few other tables with problems where one of them has too big number of columns and SOQL script cannot exceed 1000 characters. In this regards I tink is good idea to have replication exclusion list somehow configured in DBAmp
4 people like
this idea
+1
Reply
  • I suggested this sometime ago directly to Bill Emerson (the developer I think) . In my case I created a two column table, column one with a full list of table names and column two with a True/False, then in the stored procedure refreshall (or replicateall) add:

    if (select [Replicate] from TablesToReplicate where Tablename = @tn) = 'False' CONTINUE

    It just needs to be somewhere around " if @tn = 'UserProfileFeed' CONTINUE"

    But I still agree, it would be nice to refreshall and replicateall to build this in.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • To extend this idea a bit further it should be separate list for replication and refresh:
    For instance replication of attachments takes ages so I prefer to exclude attachement table from replication but still want to keep it in refresh. This table maybe never changes structure and daily does not grow too much so by having this ability I can have all attachments available localy with no much problems.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I think even just the ability to only refresh tables that are already replicated would be great. I can certainly code that on my own (and will likely do so), but an option to refreshAll to only refresh local tables would be great.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I would like to see an exclusion list pointer in the standard DBAmp procs that reads a list or something. I am not a true DBA so I may not be using the correct terms. But after I upgrade DBAmp I have to manually copy and paste the exclusion list into the DBAmp procs! I want to have the list some where seperate that DBAmp upgrades always point to but do not overwrite during upgrading. While we are at it have the DBAmp path in a seperate place too so that if someone had to install on a different drive the DBAmp procs do not have to be updated manually after a DBAmp upgrade..
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Somewhat late to the party, but we added a little routine that somewhat replaced our sf_refreshall procedure. It essentially looped though a driver table, calling sf_refresh for each object named in the table. We also had other columns in the driver that allowed different sets of objects to be processed in different groups.
    So we didn't need to touch procedural code, at least not much.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • A feature to skip tables in the SF_ReplicateAll and SF_RefreshAll stored procedures was added in version 3.3.5

    Take a look at section: "Skipping Tables in SF_ReplicateAll and SF_RefreshAll" in Chapter 3 of the DBAmp Doc for more information: http://forceamp.com/hats/DBAmpDoc.pdf
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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