SQL Data Import and Export Operations

xSQL provides a number of backup options in the form of specific commands to back up the database, save a snapshot, or export the database metadata and dictionary. These operations can also be executed via the following function calls in SQL SELECT statements:

    SELECT backup('<dbsFile-path>', '<logFile-path>', nThreads);

    SELECT save_snapshot('<imageFile-path>');

    SELECT save_metadata('<configFile-path>');

    SELECT save_class('<file-path>', '<table-name>');

    SELECT load_class('<file-path>', '<table-name>');

    SELECT save_dictionary('<schemaFile-path>');

Note that if one of these SELECT statements is executed by a remote client, all file paths refer to the server's file system.

XML Import and Export in SQL

    SELECT export_xml('<file-path>');

    SELECT import_xml('<file-path>');

The wrapper APIs provide the same logical XML export/import functionality as SQL export_xml() / import_xml() and xSQL exportxml / importxml, but expose it through native wrapper connections.

Details about the XML export/import functionality can be found in the XML Export/Import wrappers documentation.