From:       To:      

Home > Documentation > Oracle to PostgreSQL > Tutorial

Step 5 of 7. Conversion Settings

On this wizard screen you can customize the conversion process using the following settings:

  • Convert table definitions only - select this checkbox to convert only table definitions of Oracle data. All the data will not be migrated
  • Make names case sensitive - select this checkbox to make table and column names case sensitive. In this mode all table and column names are enclosed in double quotes to preserve upper/lower case. If you don't want to use double quotes around names in queries, keep this option inactive.
  • Skip converting indexes - select this checkbox if you don't want to convert indexes
  • NUMBER w/o precision -> bigint - select this checkbox to convert all columns having type NUMBER without precision into BIGINT (by default it is converted into DOUBLE PRECISION based on the range of accepted values)

You can handle schema in the destination database according one of the following options: