OpenSync

Home Forums OpenSync Schema Change

This topic contains 4 replies, has 3 voices, and was last updated by  Yudel Rosales 4 months, 2 weeks ago.

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

    brywhi
    Participant

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

    #64166

    Yudel Rosales
    Keymaster

    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;

    #65039

    bludban
    Participant

    Any solution to this? I have this as a requirement before I purchase… it is syncing to an existing DB and I can’t use the DBO schema.

    #65055

    Yudel Rosales
    Keymaster

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

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

You must be logged in to reply to this topic.