DB Solo 5.2


DB Solo is a SQL query tool.

  • Cross-platform SQL query tool with support for all major DBMS products
  • Multiple simultaneous database connections
  • Browse and manage database structures with a couple of mouse clicks
  • Create and drop common database objects using the advanced DBA features
  • Enter ad-hoc SQL queries in the query window that supports
    • Auto completion
    • Syntax coloring
    • Explain plan
    • Persisted query history
    • Multiple result sets
  • Script generator
  • J2EE code generator for POJOs, EJB 3.0 annotations, JDBC persistence layer using the DAO pattern, JUnit tests, etc.
  • Schema comparison tool – including schema synchronization
  • View table references in a graph or list format
  • View images stored in BLOB columns (GIF, JPG, and PNG)
  • View ASN.1 and XML data in a tree format
  • Store favorite queries and database objects

What's New Version 5.2

  • Added a data extraction tool that can extract all related rows in parent/child tables
  • Schema Comparison Tool can now compare DB2 index clustering
  • Data Compare Tool SQL script creator can insert a commit after every N statements
  • Added support for SQL Server extended properties