Import and Export facilities are integrated into SQLWizard. Using Import you can read data from other file formats into a new or an existing XDB Server table. Supported import formats include delimited and tabular ASCII files, DSNTIAUL files, and others.
Export allows you to extract entire or partial sets of data from XDB Server tables and write them to external file formats. You can also export to SQL commands (which results in batch SQL files containing appropriate CREATE and INSERT statements). The Export facility can export a subset of columns, reorder the columns, and apply WHERE criteria to selection of data.
Both interactive and batch modes are provided for Import and Export facilities.