comdb2 icon indicating copy to clipboard operation
comdb2 copied to clipboard

Implement SQL-based Import

Open morgando opened this issue 1 year ago • 0 comments

Depends on: #4591

The changes in this PR implement SQL-based import.

Clients will now be able to import a table by running IMPORT <src_tablename> FROM <src_dbname> TO <dst_tablename>. src_tablename and dst_tablename must refer to tables that exist. These tables do not need to have the same schema. The data in the destination table is overwritten with the contents of the source table. Databases need to have same datastripe/blobstripe settings and tables must not have any foreign key constraints.

Unlike the current import method, there is no downtime on the source database.

morgando avatar Jun 04 '24 20:06 morgando