On the Data Import > Destination tab, select a desination table for import and then click Next:
To create or edit Oracle server connections, use the corresponding options.
On the Data Import > Mapping tab, dbForge Studio will automatically create and map all the columns in a Target database to the Source columns.
You can see the Target columns on the top and the Source columns at the bottom of the wizard page. To remap columns, click Source column fields and select required columns from the drop-down list.
Note
To cancel mapping of all the columns, click Clear Mappings on the toolbar. To restore it, click Fill Mapping.
You can edit the Target column properties by double-clicking them on the top grid. Select the Key check box for a column with a primary key and click Next.
On the Data Import > Output tab, select output options to manage the data import script and click Next:
To close the wizard, click Finish.
Note
You can save the import settings as a template for later use. To save the selected settings, click Save on any wizard tab. Next time you should only select a template and specify a location of the Source data - all the settings will be already set. For more information, see Saving and Using Templates.