Each supported DBMS uses its own set of built-in data types. Some DBMS also allow to extend it with a set of user-defined data types. KS DB Merge Tools for Cross-DBMS calls these data types as native data types. To be able to compare some native data type with some other native data type from a different DBMS, KS DB Merge Tools for Cross-DBMS introduces the concept of generic data type: it is Number, String, Binary, Boolean, DateTime and Other. For example, a column of MySQL DECIMAL data type can be compared with a value of PostgreSQL smallint because both of these types are mapped to the Number generic data type.
Data types which are specific for the given DBMS or which can not be compared with most other DBMS, such data types are mapped to the Other generic data type. For example, dbAttachment MS Access data type is mapped to Other because this data type allows to store not only file body but also file name and it is a list of files, not a single blob value Values of Other data type can not be compared with each other.
This section contains mappings of native data types to generic data types for each supported DBMS:
Last updated: 2023-10-06
