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

Changing destination schema of Salesforce tables

I would like to have all my local copies of salesforce tables in a schema called [sf]. Currently, the tables are going into [dbo]. How do I change that?
1 person has
this question
+1
Reply
  • The product stored procedures do not have any reference to schema at all. Tables are simply created in the schema of the user that is running the procedure. You should be able to change the default schema of the user is running the procedure to force DBAMP to create in your schema.

    However never allow multiple schema be used in the back up database. All tables in the database must be the same schema or errors will occur.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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