OpenSync

Home Forums OpenSync Schema Change

This topic contains 2 replies, has 2 voices, and was last updated by  brywhi 2 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #64162

    brywhi
    Participant

    How can I change the schema from dbo to something different on a SQL server target DB?

    #64166

    OpenSync doesn’t support changing dbo prefix from the table name.

    #64178

    brywhi
    Participant

    Is DBO hard coded or just it just use the default for the user?

    I’m wondering if I changed a user’s default to something other than DBO, would OpenSync write to the new default?

    ex:
    ALTER USER OpenSyncUser1 WITH DEFAULT_SCHEMA = MySchema;

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.