ProSQL 2 features:

  • Connects directly to MySQL, PostgreSQL, OpenBase, FrontBase, and ODBC-accessible database servers.

  • Integrated ProSQL single-user database engine for local data storage, reporting, and backup.

  • Displays tables, fields, and server data in independent browser windows.

  • New Table tool: helps build database tables without any knowledge of SQL, with various field options and controls.

  • HTML reporting creates ready-to-publish static Web pages with any database content.

  • Microsoft Excel™ reporting: Customize database reports for Excel™ to view, customize, or print.

  • SQL Console: SQL testing and query tool for advanced users.

  • SQL Script Builder: ProSQL's integrated SQL scripting system.

  • AppleScriptable for automated queries and commands.

  • Drag-and-drop delimited text import utility.

  • XML reporting: export any query to a raw XML format for parsing by other local or remote applications.

  • Creates and imports 'SQL dump' files -- a single text file with all of the SQL commands necessary to reproduce both the schema and data in that database.