Comparing SQL Data Types


SQL data types from different database products may be compared for similarities and differences using the Compare Data Types feature.

The aim here is to find those data types across different database products that most likely match each other. This is often required when porting a database schema from one product to another.

Note: For effective results this feature requires two connections from two different database products.
  1. Select the menu item Database > Compare Data Types or the Compare Data Types button from the main tool bar
  2. Select the two connections to use for the comparison. The first connection is used as the 'master' connection against which the comparison is made.
  3. Select a data type from the first connection to display equivalent data types from the second connection
  4. Examine the specific data type differences within the lower table data type meta data comparison
The first connection always remains the 'master' connection. Its data type meta data is included in green as the first row of the meta data table. Any differences noted between the data types will be highlighted in yellow.