Schema Change - QuickBooks API / Integration Forums

OpenSync

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

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

Author
Posts
September 4, 2018 at 11:37 am #64162

brywhi
Participant
How can I change the schema from dbo to something different on a SQL server target DB?
September 5, 2018 at 10:52 am #64166

Yudel Rosales
Keymaster
OpenSync doesn’t support changing dbo prefix from the table name.
September 6, 2018 at 5:45 pm #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;
February 28, 2019 at 10:57 am #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.
March 4, 2019 at 1:19 pm #65055

Yudel Rosales
Keymaster
OpenSync doesn’t support changing dbo prefix from the table name.
Author
Posts

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

You must be logged in to reply to this topic.