DbSync does not have support for changing table types from non-inheritance to inheritance after the table is synced initially. This state is currently only handle on new table adds.
Runtime issues will be hit whenever a table changes inheritance type as dbsync currently does not correctly honor modifying the table inheritance type.
This hotfix adds support for non-inheritance to inheritance table metadata changes and vice versa. The fix takes into account on update of a tables metadata whether or not the table supports inheritance and if the RelationType column needs to be added or removed appropriately.
Article ID: 4043288 - Last Review: 16 Sep 2017 - Revision: 1