Mapping Warnings

After objects are mapped for comparison and synchronization, you may encounter warnings on the Mapping page of the Data Comparison wizard. The warnings may be divided into two groups. They are table-level warnings and column level warnings.

Table-level warnings are displayed as icon in the column with check boxes on the Mapping page of the Data Comparison Wizard. Object pairs with table-level warnings are not compared. They are displayed with icon instead of check box in the Data Comparison document.

Column-level warnings are displayed as icon in the Columns in Comparison column on the Mapping page of the Data Comparison wizard. They also appear in the Target column in the Column Mapping dialog box. Such warnings mean that some columns of a compared object pair cannot be compared because of type incompatibility or that you may encounter data loss when synchronizing data.

To read the warning messages, point to the warning icon. All warnings for this object will appear in the hint.

The following table contains information about table-level warnings and ways to remove them.

Warning Description
No columns to compare. It means, there are no columns with the same name in this pair of tables (views). To compare them you should map the columns manually. For more information about the column mapping, see Mapping Columns.
Objects to compare have no key column. It means that custom comparison key is used but is not set. You should mark at least one column pair as comparison key. For more information visit Setting Comparison Key.

The following table contains information about column-level warnings.

Warning Description
Numeric columns have different precisions, migrating the data may cause overflows. This warning appears when source numeric columns have larger precision than target column. In this case source may contain larger values than the target column can contain. Records containing such values cannot be synchronized.
Decimal columns have different precisions or scales, migrating the data may cause rounding or overflows. This warning appears when Decimal columns in source have larger precision and/or scale than target columns. If the source column contains larger values than the target column can contain, such records cannot be synchronized. If the source records contain numbers with fractional part longer than target scale, such numbers will be rounded during synchronization.
Numeric columns have different precisions, migrating the data may cause rounding. This warning appears when comparing float or integer columns and precision of source column is larger than the precision of target column. If the source float column contains data with larger precision, such data will be rounded when synchronizing. If the source integer column contains larger values than the target column can contain, such records cannot be synchronized.
Columns have different sizes, migrating the data may cause truncation. This warning appears when comparing binary or text columns and source column has larger size than target column. If source contains records with longer data than target can contain, the data will be truncated in the target when synchronizing.
Types are incompatible. These columns cannot be compared. Appears when data of the source column cannot be converted to the data type of the target column, for example TEXT and BINARY.
Source column allows Nulls which can not be stored in Target. This warning appears when source column is nullable and target column is not. If source table contains data with nulls in this column, such data cannot be synchronized.
Timestamp column cannot be updated. This warning appears when target column has a timestamp data type. Such columns cannot be updated, so their values will not be synchronized.
Xml columns have different storage types CONTENT or DOCUMENT. This warning appears when Xml columns have different types - CONTENT or DOCUMENT. Data in such columns can not be synchronized.

Note

You may exclude columns from comparison and synchronization either by unmapping them or by clearing check boxes in the first column of Select columns for comparison grid on the Column Mapping dialog box.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?