Resolve synchronization issues

When you synchronize a source table that contains NULL values with a target table that has NOT NULL constraints, dbForge Studio identifies these cases as potential conflicts and displays them on the Issues page of the Data Synchronization Wizard.

Resolve the conflict

To resolve a conflict, select one of the following options:

• Use target default value
• Specify user value
• Ignore issue

Use target default value

This option enables you to apply a DEFAULT value defined for the target column. When you select this option, the following message appears:
NOT NULL value will not be set.

Note

This option is available only if the target column has a DEFAULT value.

If the target column has a NOT NULL constraint and a defined DEFAULT value, Use target default value is selected by default.

Specify user value

This option lets you manually define a value for each conflicting pair. You can add quotation marks if the data type requires them. When you select the option, the following message appears::
User value should be set in the correct format for <datatype> data type.

You must enter the value in the Value column. When you hover over in the Value column, a tooltip shows the format you should use for that data type.

Ignore issue

This option lets you leave the issue unresolved without applying any corrective action. When you select this option, the following message appears:
Inserting or updating operations will fail if the source column has nulls.

If no default value is defined for the target column, Ignore issue is selected by default.

Note

You can use dbForge AI Assistant to analyze synchronization errors and explore the ways to handle them.