Home > Documentation > MS Access to Oracle > Tutorial
Step 3 of 5. Conversion Settings
On this wizard screen you should select source MS Access database. Also, you can customize the conversion process using the following settings:
- Convert table definitions only - select this checkbox to convert only table definitions of the original MS Access database
- Skip converting indexes - select this checkbox if you don't want to convert indexes
- Make names uppercase - Oracle accepts lowercase names but you have to enclose them in quotes in queries. To avoid this problem you should select this checkbox.
Access-to-Oracle allows you to choose how to process MS Access tables that already exist in the destination Oracle database: overwrite, skip, merge or synchronize.
- Select 'Overwrite' option to replace the contents of existing Oracle tables with MS Access data.
- Select 'Merge' option to merge MS Access data into the destination Oracle database. Learn more about merging in Access-to-Oracle converter.
- Select 'Skip' option to not convert existing tables.
- Select 'Synchronize' option to update Oracle table using MS Access data. Learn more about synchronization in Access-to-Oracle converter.
Have questions? Contact us