Previous Topic Next topic Print topic


Introducing Export

SQLWizard Export allows you to transfer the contents of any XDB Server table or view into a file in any of the supported file formats. You can export the columns of an existing table in any order or export a subset of the columns. In addition, you can specify a WHERE condition to export only selected data from the original table. Features are available to log the export process, set your own defaults for various export options, and set up and run Batch Export commands.

Batch export is particularly useful if you repeatedly export data from the same tables. Each time you open an Export window and provide export specifications and then save the specifications to a file, you create a Batch Export file. Before using Batch Export, you should be familiar with interactive export for the type of file to which you are exporting.

The following is a list of file formats supported by SQLWizard. Depending on the format you select, you may need to specify a number of options before activating the export.

Note: XDB Server indexes are specific to the XDB Server environment and are not relevant to any other environment. Index information is environment-specific and depends on the operating system. Therefore, SQLWizard Export will not export the indexes when it exports a table. However, if exporting to SQL statements, you can generate the SQL CREATE INDEX command that will re-create an index on an XDB Server or DB2 system.
Previous Topic Next topic Print topic