Help Center/ GaussDB(for MySQL)/ FAQs/ Database Migration/ What Types of DB Engines Does GaussDB(for MySQL) Support for Importing Data?
Updated on 2024-09-05 GMT+08:00
View PDF
Share

What Types of DB Engines Does GaussDB(for MySQL) Support for Importing Data?

  • Exporting or importing data between DB engines of the same type is called homogeneous database export or import.
  • Exporting or importing data between DB engines of different types is called heterogeneous database export or import. For example, import data from Oracle to the DB engines supported by GaussDB(for MySQL).

    Generally, data cannot be exported or imported between heterogeneous databases due to the different data formats involved. However, if the data formats are compatible, table data can, in theory, be migrated between them.

    Third-party software is usually required for data replication to export and import between heterogeneous databases. For example, you can use a third-party tool to export table records from Oracle in .txt format. Then, you can use Load statements to import the exported table records to the DB engines supported by GaussDB(for MySQL).

Parent topic: Database Migration