Backup database as "Data archive" - ZIP file - platform and database independent backup
Ability to use native backup tools (mysqldump, pg_dump)
Restore from backup, restore whole database or selected tables (selecting tables is possible only when using data archive as backup format)
Export of table data to formats CSV, TXT, HTML, XML, SQL, Excel
Import of table from formats CSV, XML
Export database structure into formats HTML, WIKI
Copy database/table to another server using drag & drop
Transform table data when copying or exporting table. Columns can be reordered, column value can be fixed or transformated using Python. Transformation can be saved and later reused.
Any data operation can be saved as job and executed later, also from command line
Scheduling using Windows Scheduler Service (applicable to any type of job)
Choosing backuped objects
CSV export properties
Process window
Column mapping and transformation
Import from text file
Import from text - can be used for importing smaller data amounts to single table, has lot of text-analyser features (regexes etc....)
Source can be URL, file, text in clipboard
Row can be detected using regular expressions, or using delimiter (one delimiter is end of line => one line creates one row)
Fields of row can be detected again using regular expressions or using delimiter
Standard row transformations (including Python macros) can be used for transforming output rowset
Export to multiple files
can be used for exporting data-driven file structure
you should insert query, which results are interpreted as file names
file content can be one field (eg. BLOB fields), any tabular data format (CSV, HTML, Excel etc...) which supports file-output protocol, or template generated from database (similar to PHP code)