Set the target database format
After do this step, please click the Next button to go to the next step.
The first step, you should assign which Driver Config should be used to build the source database connection.
All the MS Excel JDBC Driver configs configged before will show in the JDBC Driver list,
After you have selected the correct JDBC Configs, the window will show the information about this JDBC Configs, and show a JDBC URL example syntax for build a connection, and the properties you can set when build connection.
Here i input an example for export data, you can change the properties accord your needs.
After do this step, please click the Next button to go to the next step.
The first step, you should assign which Driver Config should used to build the target database connection.
All the Oracle JDBC Driver configs configged before will show in the JDBC Driver list,
After you have select the correct JDBC Configs, the window will show the information about this JDBC Configs, and show a JDBC URL example syntax for build a connection, and the properties you can set when build connection. Here you should assign the target Oracle database connection properties, for example, Oracle file path, the other properties.
After do this step, please click the Next button to go to the next step.
The first step, you should select the schema. All schemas your connection can access will show in the Select Source Catalogs List, by default, it will automatic select the first item in this list. If you change the selected item at this list, you will find the tables in "Table List" would change, it will list all tables your connection can access owned by your selected schema.
You should assign the selected table would export to which catalog in target database. All catalogs will been showed in the "Select Dest" list.
You can create new schema by click the "Create schema" button. It will create the new schema accord name you input.
After you selected the tables which wanted to been exported and assign the target catalog, you can click the ">>" button to set exported tables. If you want to remove the tablex which have been set to exported, you can click the "<<" button after you select the them from the right listbox.
After do this step, please click the Next button to go to the next step.
This step is used to let you confirm all the tables exported to the target tables. Here you remove all the tables you don't want to export to the target tables.
This step is used to let you confirm all the exported tables which have existed in the target tables. If the tables have existed in the target database, maybe you hope confirm whether the tables is really want to be exported. If you're very sure that you want to export the tables, you just click the Next button.
You can remove multi table when click "Remove the selected tables" button or "Remove tables which export to target" button. The difference is that if you click the "Remove the selected tables" will remove the selected tables in "Table Exported Existed Table" list and the "Remove tables which export to target" will remove all tables exported the target tables you selected in "Existed Target Tables" list.
Sometimes the source table and the target table have the different columns or have the type uncompatiable columns, Here you can see this tables in the left list.
Select a item at the left list, the right two lists will show the target table columns and the source table columns, you can see some column items will marked with red color which means this columns is type uncompitiable, or no map source columns(if it is in the target table column list), or no map target columns(if it is in the source table column list). You can remove this target tables by click "Remove target export" button.
This step is used to let you confirm the tables would be created in the target database, here you change one column type's size and scale for a table, or remove the exported tables if you want create the tables in target database.
Here maybe you should pay a little attention to the table which marked with pink color. It shows one column of this table is not compatiable with the new column in size or scale. In the follows picture, the selected column has the 2000 size , but the new column type has maxiumn 255 size, so it maybe not compatiable.
The table marked with normal color(black) will show all columns of it is complete compatiable to all columns of new created table.
Though we don't advise you change the column type in new created tables, but if you really to do so and confirm it is no any type convert problem, you can change the column type ,and the size, and the scale. You should select the expected column type ,and maybe you should set the new size and new scale too, and then click the "Set This Column" button. If you forget click this button , the change will be invalid.
After you changed the column type in new created tables, you can find the column you changed just will marked with red color. It show that this column have been set to a uncompatiable column type, and so, the table with the column wouldn't exported for type convert problem.
If exists column type uncompitable or column type size uncompitable,it will show a dialog to let you confirm this config after you click the "Next" button.
For Oracle database table, it limit one table have maxium one LONG or LONG RAW type columns, so if you assigned one table definition with two LONG or LONG RAW columns, it will show the followed information, and you must change this tables column definition.
This step is do the export operation accord the prior configuration.
Here you can config whether continue export the rest table when error happens in the procedure for exporting tables, and if you set continue export the rest table, you can config whether export the rest records of this table wich errors.
Only after you check "Continue export the other table when error happens", you can checked "Continue expor the rest records when export a record failue".
The "Continue export the other table when error happens" checkbox is used to set whether continue export the rest table when error happens. The "Continue expor the rest records when export a record failue" checkbox is used to set whether export the rest records of this table wich errors.
After you configed,you can click the "Do Export" button,it will show the last dialog to let you confirm whether really export data.
After if you click the "Yes" at the upper dialog, the export procedure will execute and the exporting information will show in the textbox.
