Supported databases

• MySQL from version 3.2x
• PostgreSQL 8.0
• MS SQL Server from version 7.0
• Access from version 97
• Visual FoxPro from version 7
• Excel from version 95
• dBase/FoxPro III,IV,V
• Paradox 5.x
• SQLite from version 3.0
• Text databases (CSV)
• Outlook

Copy, update, align

• Copying complete tables
• Data alignment of individual fields
• Copying password-protected Access and Paradox databases
• Five different copy modes:
  1.) Update without deleting the destination tables
  2.) Copy with previous deletion of the destination tables
  3.) Add new datasets (requires Primary Key)
  4.) Update data records (requires Primary Key)
  5.) Update without addition of new data records (requires Primary Key)
• Data filter for source table (e.g. id > 300)
  

Browsing and editing data

• DB-Viewer
• Updating, deleting, adding data
• Adding, deleting data records
• Duplicating data records
• Data filter for limiting the data
• Automatic width adjustment of the column (adjustable)

SQL

• Executing SQL queries

Editing table structure

• Showing table fields/-types
• Adding, deleting, editing fields *
• Editing field attributes (Primary Key, autoincrement, NULL,...) *

Migration/Export

• Copying/transfering the table structure to equal and other databases
• Export to SQL-script
• Export to text file (*.csv)

Settings

• Country-specific settings (in and output format)
  - date/time format
  - currency
• Decimal separator (in and output format)
• Limit data for browsing

Miscellaneous

• Copy wizard
• Saving connections
• Saving profiles
• Import/Export profiles
• Logfile
• SQL Log
• Easy installation by means of a set-up program
  

Requirements

• Windows NT 4.0, Win 2000/XP, Windows 2003 Server
• Current MDAC (Microsoft Data Access Components) version and JET database driver (see FAQ)