The Data Type Mappings page of the Options dialog box allows you to determine how data types are mapped from the source database to the destination database. These settings apply to all tables that are mapped.
During the mapping phase, the Migration Workbench chooses the bigger of the length/precision or scale defined in this page and the length/precision or scale defined in the source table that you have captured. For example, if the source table has a column defined as varchar(100) and you change the data type mapping for varchar to varchar2(50), the table column will be mapped to varchar2(100). Similarly, if the data type mapping for varchar is defined to be varchar2(200), the table column will be mapped to varchar2(200).
This page displays an editable spreadsheet that contains the following columns:
The data types in the source SQL Anywhere database.
The possible Oracle data types to which the data types from the source database can be mapped. Some cells contain a drop-down list that displays alternative Oracle data types. Click the arrow to display the list, move the cursor over the required data type, and click to select that data type.
The maximum number of digits or characters that are permitted for alphanumeric data types. To specify the length/precision for an alphanumeric data type, enter the required value, or select and overwrite the existing value in the spreadsheet cell for that data type. You will not be allowed to edit the cell if it is not applicable for the type displayed in the Oracle column.
The maximum number of digits to the right of the decimal point in a numeric data type. To define a new scale of numeric data types, enter the required value, or select and overwrite the existing value in the spreadsheet cell for that data type. You will not be allowed to edit the cell if it is not applicable for the type displayed in the Oracle column.
A scroll bar is provided at the right-hand side of the spreadsheet to enable you to scroll through the rows of the spreadsheet.
This page also contains the following command buttons:
Records the options you have specified and exits the Options dialog box. If you have made any changes to the default data type mappings, a dialog box appears. This dialog box confirms that you have made some changes, and advises you to click OK to remap the Source Model so that these changes can take effect.
Exits the Options dialog box.
Displays online help about the Options dialog box.