OceanBase Loader and Dumper
OceanBase Loader and Dumper are developed based on Java for importing and exporting data. OceanBase Loader provides extensive command-line options that allow you to import schemas and data to OceanBase Database in many complex scenarios. We recommend that you use OceanBase Loader along with OceanBase Dumper. However, OceanBase Loader can also import SQL and CSV files that are exported by third-party tools, such as Navicat, MyDumper, and SQL Developer. OceanBase Loader fully uses the features of the distributed OceanBase Database system. The tool is particularly optimized for import performance and stability, and is enhanced to provide more operation monitoring information to improve user experience. You can use OceanBase Dumper to export data objects and relevant data in OceanBase Database to files.
DownloadBuild a Business System
Import and Export Data in OceanBase Database
Import and Export Data Across Platforms
- 1Use OceanBase Loader to import data within OceanBase Database
OceanBase Loader can import definitions and data to OceanBase Database based on specified command-line options. You can import data from files in the CSV, SQL, ORC, or Parquet format.
For more information, see "User Guide (OceanBase Loader)".
- 2Use OceanBase Dumper to export data within OceanBase Database
OceanBase Dumper can export definitions and data from OceanBase Database based on specified command-line options. You can export data in tables to a file in the CSV, SQL, CUT, ORC, or Parquet format.
For more information, see "User Guide (OceanBase Dumper)".
Dive Deep into OceanBase Loader and Dumper
- Use OceanBase LoaderDocuments
Learn more about OceanBase Loader
- Use OceanBase DumperDocuments
Learn more about OceanBase Dumper
