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

Connect to multiple Salesforce and create seperate Linked Servers for each connection

What is the best way to create two Linked Servers one for each Salesforce. Also, have seperate [salesforce backups] DB for each Linked Server.
1 person has
this question
+1
Reply
  • Just create the second linked server and give the 2 linked servers separate names.

    Then create a separate database for the local tables of the second org. Be sure to populate the DBAmp Stored Procs into the new database by running the Create DBAMP SPROCS.sql script.

    Also, if the second org is NOT a sandbox of your licensed org, you will need to purchase an additional DBAmp license. DBAmp is licensed to the salesforce.com org and includes all sandboxes of the licensed org.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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