The data export process is extraction data rows from the database table, view or query to external format or some human-readable presentation. DTM Migration Kit supports most popular formats and has been designed to help DBA, advanced users, and system administrators to automate data export. Moreover, the export data tool is compatible with scheduled job execution.
There are formats available for export to text files, HTML documents, RTF (Microsoft Word and Open Office Writer Compatible), Excel spreadsheets, XML documents and SQL scripts. Also, DTM Migration Kit can save binary data to external files, one per BLOB (binary large object). There are options for text file export: delimited text with a predefined or custom separator, CSV files, and fixed-width output.
For complex export cases, the migration tool provides transformation functions: mapping, character encoding modification, etc. Also, the program supports two modes for XML export: name-as-attribute or name-as-tag.
Let's describe main reasons to export data rows from database to mentioned formats. There are two groups: presentation purpose and information systems interconnection. The first group consists of human-readable formats like Word, Excel or HTML when the second - machine-readable - XML, SQL, text. The formats like HTML are suitable for publication data in scheduled manner. For example, the company can run some complex query daily and publish the results at the web site.
The second group of formats is suitable for data exchange. All of them have well known format and can be loaded to another information system or business application. The SQL script can be imported into another database directly.
For Microsoft SQL Server and Microsoft Access the export tool supports special modes for Identity/Counter columns: export or ignore. Also, it can export CLOB (character large objects) to separated files (one per object).