I'm using CData Sync with a SQL Server source in a Standard job (incremental check column, no CDC or CT enabled). If a new column is added to a source table, will Sync automatically detect and add it to the destination on the next run? The Features page says schema changes are detected "in every run", but the SQL Server Source page only describes this behavior under CT/CDC. Does it work without CT/CDC enabled?
Question
CDC/CT required for Sync All or Alter Schema?
Hi
In Sync, we have a property called Alter Schema, which allows jobs to add columns and alter data types in the destination table when there is a mismatch between the source and destination table metadata.
You can find this property in the Advanced section of your job, under Replicate Options:
By default, this setting is enabled, meaning that your incremental job will automatically detect changes in the source schema and make the necessary adjustments to the destination table.
That said, you can disable or enable this setting according to your requirements. Please note that if a column is added to the source table, it will also be added to the destination table. However, if a column is removed from the source, it will not be removed from the destination unless the destination table is dropped and recreated.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.