|Managing Your Data in GemFire XD / Exporting and Importing Data with GemFire XD|
The gfxd utility provides several commands that use the DdlUtils 1.1 API to export and import database schemas and table data. You can use these gfxd commands with GemFire XD and other JDBC datasources.
As with the import system procedures (see Exporting and Importing Bulk Data from Text Files), the GFXD commands for importing data can optionally use the skip-constraint-checks and skip-listeners connection properties to relax table constraints and bypass listeners when importing data. This can be especially helpful with HDFS-persistent tables, where constraint checks may need to access data that is persisted in HDFS rather than in operational memory.
When you migrate a third-party database schema to GemFire XD, use gfxd write-schema-to-sql and then modify the SQL statements to include GemFire XD-specific features such as table partitioning and replication. Then use an interactive gfxd session to execute the script in GemFire XD. See run.
When you migrate a schema from one GemFire XD system to another, use gfxd write-schema-to-xml or use gfxd write-schema-to-sql with the -export-all option to include GemFire XD-specific extensions in the DDL commands.
The sections that follow describe how to use the above gfxd commands to migrate a third-party database to GemFire XD.