Wizard for Importing data from SQL Server to Oracle

Click "Wizard - Import From Table" at task dialog.

Import Data From SQL Server to Oracle - Task Window

then show the wizard.

1. Open Source table.

SQL Server to Oracle wizard - Open Source

2. Select a destination table and config fields.

SQL Server to Oracle wizard - select table

3. Preview data.

SQL Server to Oracle wizard - preview

4. Import.

SQL Server to Oracle wizard - import

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.