From:       To:      

Home > Documentation > Oracle to MySQL > Tutorial

Step 5 of 6. Select Tables

On this page Oracle to MySQL converter allows user to select tables and to compose filtering queries for migration to MySQL server.

To add new Oracle table for converting into MySQL format, select it in "Available tables" list and click "Add" button (or double-click the selected item). Use "Add all" button to add all tables available in Oracle database. To remove a table from "Selected tables" list highlight it and click "Remove" button. Use "Remove all" button to remove all items from "Selected tables" list.

Use "Add Query" button for composing SELECT-query to filter, to group or to merge data that will be migrated to MySQL. See Using Queries article for the further information.

To edit table or query double click the corresponding item in "Selected tables" list box. If it is a table, dialog box appears to edit table attributes and to define custom type mapping. See Edit Table article for the further information. If selected item is a query, you will see dialog box to edit SQL-statement of the query.

Have questions? Contact us