10.2.3 Migrating from unsupported (generic) databases
10.2.3. Migrating from unsupported (generic) databases
Most ODBC compliant databases may be migrated using the generic
database support. In this case, code objects will not be
retrieved from the source database; only tables and data.
When using the generic support, column datatypes are mapped
using the following steps:
It searches for the first entry in the Generic
Datatype Mapping Table for the source type name.
If the length/scale ranges of the entry matches the source
column, it will pick that type. Otherwise, it continues
searching.
If no matches were found in the generic table, then it tries
to directly map the source type to a MySQL type of the same
name.
If the source type name doesn't match any of the MySQL
datatypes, thenit will not be converted and an error is
logged. You can then manually specify the target datatype in
the Manual Object Editing step of the wizard.
© 2013, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.