Multiple Data Export Formats
DatabaseSpy® 2016 lets you select any table or view from any connected database for export. If you select multiple tables or views for export, each is written to a separate file. You can also export XML, XML Structure, CSV, or HTML directly to Altova XMLSpy. When you’re working in the SQL Editor you even have a dedicated Export button to let you instantly open an export dialog box pre-loaded with your current SQL Editor statements.
DatabaseSpy supports five formats for data export. For XML export, each row in the table is exported with an identifying <Row> XML element and each column entry is identified by an XML element that matches the column name. For XML Structure exports, each row in the table is exported with an identifying XML element that matches the exported table name. For export as CSV, each row is exported as plain text, with multiple delimiter and newline options. For HTML, each row is exported with HTML coding to form an HTML table that can be opened in a Web browser or incorporated into a larger HTML page. Excel format is exported directly to a Microsoft Excel spreadsheet file.
DatabaseSpy allows you to fine tune the content of the output with special refinement options for each format.
The Export Preview feature lets you do much more than simply preview the data you have selected for output. You can click the column header row to rename columns in your output, delete individual columns, or adjust column output options.
Data Import Options
DatabaseSpy lets you import data into your databases from conventional CSV files or from files containing XML data. Using either format, you can create new tables or update existing tables in your database.
The Import option in the Tools menu or the Import button on the main DatabaseSpy toolbar opens an Import dialog to set the import source, choose options, and see previews of your data import request.
The XML import option can help ease the transition between modern XML-based applications and legacy relational databases, with special XML-aware options to process data during import.
Convert and Import Data
If you need to convert data from a dissimilar format before importing it to your database, Altova MapForce® 2016 is the visual mapping tool with the power to map any combination of XML, database, text, or EDI files. Altova MapForce can connect to all major databases and convert source data on the fly for direct insertion.