EMS Data Export for MySQL swiftly exports MySQL database data to 19 compatible formats such as MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF, and more.
One of the most impressive features of Data Export for MySQL is its ability to handle Unicode data. This allows you to export data from multiple tables, views, or queries simultaneously, giving you the flexibility and control you need to manage your database.
The program also includes a wizard that enables you to visually set MySQL export options for each table. You can specify the destination filename, exported fields, data formats, and more with ease. Additionally, the command-line utility allows you to export MySQL data from tables and queries with just one-click.
Key features include the ability to select fields to export and change their order, adjustable parameters for each exported table, and specific parameters for each output format. You can even save all of your export parameters to the configuration file for future use, and automate your export jobs using the command-line utility.
Data Export for MySQL also supports the latest version of MySQL, and you can connect to MySQL Server through HTTP protocol, or via local port forwarding through the SSH tunnel. The user-friendly wizard interface makes it easy to get started with exporting your data and managing your database.
Version 3.3:
When exporting from a SQL query, the query text can be added both to Header and Footer.
It is now possible to define size and decimal for float fields when exporting to the DBF file.
Some other improvements and bugfixes.
Version 3.2:
- The Support of the latest DB Servers added
- When exporting data to SQL Script, BLOB (MEMO, BLOB, CLOB, etc.) data are formatted according to the destination server syntax
- Added the possibility to set page orientation when exporting data to MS Word 2007
Version 3.1:
Added the possibility to select the file encoding when exporting to TXT (ANSI, OEM, MAC, UTF8, UTF16, UTF32).
Added the possibility to generate the 'IDENTITY_INSERT' SQL statement for export to MS SQL script
Now the 'Destination Directory' value is saved to the template
Version 3.0:
-Unicode support
- Export into new formats: Office 2007, Open Document Format,
Generic XML with XSD
- Use parameters in data export queries
- Utility source code significantly optimized, work speed increased.
- Select destination server when exporting to SQL format
- Other improvements and bugfixes
Version 2.3:
- The amount of memory consumed is significantly decreased when exporting large files.
- Now the databases in lists are sorted.
- Other improvements and bugfixes.
Version 2.2: Ability to connect through SSH and HTTP tunnels, other improvements and bugfixes...