Languages

Backup, export, import

  • 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)