Share this
Home › Forums › OpenSync › Schema Change
This topic contains 4 replies, has 3 voices, and was last updated by Yudel Rosales 1 year, 11 months ago.
How can I change the schema from dbo to something different on a SQL server target DB?
OpenSync doesn’t support changing dbo prefix from the table name.
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;
ALTER USER OpenSyncUser1 WITH DEFAULT_SCHEMA = MySchema;
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.
You must be logged in to reply to this topic.