The correct method for migrating mysql Data to Oracle is mysqloracle.

The correct method for migrating mysql Data to Oracle is mysqloracle.

There is a table student in the mysql database. Its structure is as follows:

There is a table from_mysql in the Oracle database. Its structure is as follows:

Now we need to transfer the data from the mysql student to Oracle's from_mysql. Here I use kettle's spoon tool to quickly implement this function.

First, open spoon and create a new conversion named "table input to table output. Then, find the table input from the input in the core object, drag it to the editing interface, and then find the output from the output to the editing interface to connect the table input and table output ,:

Right-click table input and select Edit step. The following window is displayed:

Select the connected data from the database connection, and select mysql here. You can click Edit to modify the database. If you have not configured a database, click Create to configure the database. For more information, see kettle-configuration resource library.

Enter an SQL statement in the SQL input box to filter the data to be migrated. If the SQL statement contains variables, replace the variables in the SQL statement with a check box.

Right-click the table output and select Edit step. The following window is displayed:

The database connection is similar to the input in the table, but Oracle is selected here, And from_mysql is selected in the target table, because we choose test data and the data volume is not large, therefore, the number of submitted records is retained by default.

Next, create a job named table output. Find start, set variables, and transformation in the general location of the core object, and drag them to the editing page to connect the three objects ,:

Right-click set variables and select the edit job entry. In the displayed window, edit the variable name and value, as shown below:

Right-click transformation and select the edit job entry. In the displayed window, select the conversion name and find the saved conversion: The table is input and expressed. As follows:

So far, all the work has been completed. Click "run" to extract data from mysql and transfer it to Oracle.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.