Ispirer Website Ispirer Toolkit Overview Free Trial

Local Data Type Mapping

This feature allows you to change the default conversion of the datatype for the appropriate column. To set up the required conversion please choose the table name, where you would like to make changes, in the tree on the left, then please click the “DDL options” tab on the right and choose “Data Type Mapping” instead of “Column Name Mapping” in the combo-box. For the reference please see the screen-shot below:

Once mapping is specified, it is saved in sqlways.xml file, so the mapping can be further used in conversion using the batch mode.

NOTE: Local Data Type Mapping overrides the Global Data Type Mapping for the appropriate column.

At this tab you can also select the list of columns, which should be migrated to target database. To exclude the column from target table you need just switch off the checkbox for column:


If you have any other questions regarding the usage of our tool, please contact our support team: support@ispirer.com