WinSQL is universal database management tool that can be used with any relational database to perform administrative tasks such as importing/exporting data, generating test data, reverse engineering an existing database, comparing schema and data between databases or simply running SQL queries. On one hand WinSQL provides advanced user powerful tools to help them manage their database, on the other hand several wizards in WinSQL help novice users to view and modify existing data on any relational database. In short, WinSQL is a must-have tool for any programmer or DBA who work with a variety of databases in their day-to-day life.
How does it work?
It's simple. WinSQL can talk to any database through an ODBC driver. Most databases these days come with an ODBC driver, which in most cases 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.
WinSQL comes in three editions:
- Lite - freeware
- Developer
- Professional
