WinSQL - A "must have" utility for DBAs and programmers

WinSQL

A "must have" utility for DBAs and programmers

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.

WinSQL Profession is a tool that uses ODBC to connect to any database. Main features are * Use it as a quering tool * Migrate data from one source to another * Generate test data * Draw E/R Diagrams * Reverse engineer database schema * Print database catalog * Generate HTML files from database * Command line support .

WinSQL is a utility that uses ODBC to connect to different databases. You can connect to multiple data source at the same time. It also displays the database catalog information including table name, field name, stored procedures and their parameters. Moreover, it uses a multi-threaded architecture for better performance. One big advantage of this utility is that there is no installation. It is just one file that can be copied easily on to a floppy disk.

Key Features

Zero install solution. One small executible file. No run time DLLs required.
Syntax highlighting for SQL script
SQL wizard
New table wizard
HTML publishing wizard Export the result of a query to linked HTML pages.
Database catalog Shows tables, views, stored procedures
Run selective query Highlight part of the script and send just that to the server
Result in grid or text box
Support for database transactions
Customized editor
Data browsing
Local comment parsing
Parameterized queries
Submit batches Queries can be seperated by a seperator and therefore, multiple queries can be submitted at the same time.
Multi-threaded architecture
CREATE TABLE statement wizard
Update/Insert record wizard
Command line support
Data export wizard
Test data generation wizard
Entity Relationship Diagrams
Catalog printing
List of available datatypes

What's new in version 4.0

DSN Less connection
Enhanced results grid
Query set workbook
Inline results
SQL code templates
Enhanced SQL Query Wizard
Two-way database diff

DSN Less connections

Now you do not need to create a DNS in the ODBC manager in order to connect to a database in WinSQL. Simply select "Specify connection string" check box and specify a connection string. If you are not sure what string to provide, leave the connection string blank and WinSQL will prompt you for a DNS. Next time you try to connect the connection string will be filled for you.

Did you know that you DO NOT need to install Microsoft Access in order to use an MS Access database? You can create an .MDB file from ODBC Driver Manager and then use that file in WinSQL to issue SQL Queries. The default connection string is set to Microsoft MS Access. This makes connections to MS Access very easy.