Data Import from oracle to mysql (applicable to the mutual import between any data sources), oraclemysql

Data Import from oracle to mysql (applicable to the mutual import between any data sources), oraclemysql

To release some resources in the production database, you need to migrate the API module to mysql and export data.

When I tried the oracle to mysql tool, the Migration reports an error. Such a large amount of data is not very reliable.

We were surprised to find that there was a data migration tool in the database View tool Navicat Premium, which was used unexpectedly. This tool supports mysql, oracle, sqlLite, and PostgreSql databases. Therefore, it also provides the ability to migrate data between different databases.

Before migration, make sure that you have established the connection between the two databases. Select Tools/DataTransfer.

Select the source database and the table to be migrated.

Select the surrounding area.

Migration process. The progress is displayed in the upper left corner.

How to export data between mysql and oracle

3.2 Oracle SQL Developer
What is Oracle SQL Developer?
Oracle SQL Developer is a free and fully supported Graphical Database development tool. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of reports provided and create and save your own reports. SQL Developer can improve work efficiency and simplify database development tasks. SQL Developer can connect to any Oracle database of version 9.2.0.1 and later, and can run on Windows, Linux, and Mac OSX.
SQL Developer includes the migration workbench, which is a re-developed and integrated tool that extends the functionality and availability of the original Oracle migration workbench. Through close integration with SQL Developer, users can browse database objects and data in a third-party database in one place, and port these databases to Oracle.
Oracle SQL Developer integrates with Oracle APEX, allowing you to browse applications and execute other Application Express activities. Oracle SQL Developer allows you to browse, export, import, delete, or deploy applications. Many Application Express reports are available. you can create your own custom reports.
The latest version of Oracle SQL Developer provides integrated support for version control, source code control system (CVS), and Subversion. Version Control is supported through a file browser that allows you to browse and read files stored in the file system. You can open and edit these files in SQL Developer. In addition to these new features of SQL Developer, version 1.5 also includes many new features, such as SQL formatting, Mode Comparison, copying and exporting wizard, and Sybase porting support. Times Ten support is also integrated into this product. It also provides a list of all new features of SQL Developer 1.5.
Oracle SQL Developer migration
Oracle SQL Developer integrates with migration support, which includes the features of redevelopment and greatly extends the functions and availability of the original Oracle migration workbench, you can migrate Microsoft Access, Microsoft SQL Server, and MySQL databases to Oracle.
 Create a database connection to the following content
Using MySQL
Microsoft SQL Server
Microsoft Access
 Sybase
Browse third-party Databases
 Quick migration
Least permissions for Migration
Step-by-Step Routing
Capture third-party Models
Transform to Oracle model
DDL script generated by DIG
 Execute DDL
Migrate data to Oracle
 Fine-grained migration
Routing complex object Migration supports stored procedures, triggers, and views.
Transform translation modification Editor
Movie translation difference Viewer
Video demonstration
The following video shows how to import a database from MySQL to Oracle using Oracle SQL Developer. Click to play the video (if the video cannot be played, open MysqlToO in the browser... the remaining full text>

How can tables in the oracle database be imported into mysql?

Different database mechanisms make it impossible to import the entire database.
If there is not much data, you can use plsql developper's tool-> export tables to select SQL insert to export data.
. This will generate a general SQL insert statement.