Share this
Home › Forums › OpenSync › Schema Change
This topic contains 2 replies, has 2 voices, and was last updated by brywhi 2 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;
You must be logged in to reply to this topic.
