WinSQL is a "must have" utility for DBAs and programmers who deal with databases. It empowers them to be more productive by providing an intuitive tool that can talk to any database through ODBC.

What you can do with WinSQL lite:

  • Submit SQL Queries to any ODBC compliant databases
  • Get metadata for tables, views, stored procedures, triggers, rules, etc.
  • Learn how to write SQL statements by using wizards that build SQL for you
  • Transfer data from one source to another
  • Reverse engineer a database
  • Draw E/R Diagrams
  • Generate test data with millions of meaningful rows
  • Find structural differences between two databases

    • How does it work?

    It's simple. WinSQL can talk to any database for which you have an ODBC driver. Most of the databases today come with an ODBC driver and usually it is free. The ODBC Driver Manager gets installed on every machine with the Windows Operating System.

    WinSQL talks to the ODBC driver through the Driver Manager. ODBC Driver converts generic ODBC calls into database specific requests and sends it to the back-end server. The server computes the results and sends them back to WinSQL through the driver.

    Databases WinSQL Lite works with:

  • MySQL
  • Btrieve (Pervasive SQL)
  • IBM DB2 (Wire protocol. No client required)
  • dBase
  • Microsoft Excel Workbook
  • Microsoft SQL Server
  • Microsoft SQL Server (Wire protocol. No client required)
  • Informix
  • Informix (Wire protocol. No client required)
  • Oracle
  • Oracle (Wire protocol. No client required)
  • Paradox
  • Progress 9
  • Sybase (Wire protocol. No client required)
  • Text
    		•

    WinSQL Lite Details:
  • Submitted by: Jason Mullett
  • Date: 02/15/2004
  • Licence: Freeware
  • Operating Systems: Most Microsoft Windows Operating Systems.
  • Official Website: www.synametrics.com
  • Download Link: Download Windows Installer
    		•

    WinSQL Lite Screenshots: