Synchronizing Columns in OneData

When using the Synchronize Structure option, OneData detects all columns added or deleted, including any comments set in the remote database (Oracle 9 and above). OneData also detects any data type or constraint change (including checking constraints). For views, existing constraints are not removed. All metadata changes are propagated to production. OneData excludes system-generated check constraints (or check constraints starting with sys_).

Note:

When you use SQL Server:

If you add a numeric identity column in the database after synchronizing the structure, you must change the data type of the corresponding column in OneData to database sequence. This is necessary because OneData detects this column as a numeric column when you synchronize structure.

If you add a column in OneData through Synchronize Structure, the data type of the column in OneData changes to the default SQL Server data type supported in OneData. For example, if you add a decimal column in the database and execute synchronize structure, and then change the precision of the column in OneData, the column type changes to numeric (the default SQL server data type supported for OneData) in the database.