This is the official web site of Jason Lyn Mullett. A resource center for webmasters, network administrators, and hardware technicians.

Top Windows Articles

Configure IE to Have More Than Two Download Sessions
Open Command Prompts at Folder Level in Explorer
Resetting TCP-IP on XP
Increase hard disk speed in Windows XP/2003
More>>>>

Top Linux Articles

Recompiling the Linux kernel
More>>>>

Top DOS Articles

DOS Command List
More>>>>

Top Networking Articles

Understanding TCP-IP
TCP/UDP Ports List
More>>>>

Top Hardware Articles

RAID Explained
I/O (Input/Output) List
IRQ (Interrupt Request) List
The SCSI Standards Defined
More>>>>

Top Novell Articles

How to install the ZfdAgent through the Netware logon script
More>>>>

WinSQL Lite Overview:

Print this article Print this article
E-mail article to a friend E-mail article to a friend
E-mail the author E-mail the author

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:

WinSQL Lite Screenshots:

Thu, Feb 23, 2012

Search Site or Web:

Top Software Downloads

FreshDiagnose
WinSQL Lite
AVG Anti-Virus
Spybot Search & Destroy
More>>>>

Top Scripts

phpBB Forum
Fluid Dynamics Search Engine
Advanced Poll 2.0.3
More>>>>

M$ Security Bulletins

MS05-034: Cumulative Security Update for ISA Server 2000 (899753)
MS05-033: Vulnerability in Telnet Client Could Allow Information Disclosure (896428)
MS05-032: Vulnerability in Microsoft Agent Could Allow Spoofing (890046)
MS05-031: Vulnerability in Interactive Training Could Allow Remote Code Execution (898458)
More>>>>

Symantec Virus Alerts


Home | Feedback | Guest Book | Forum | Search Site

e-mail Jason Mullett, Copyright © 2002, 2003 jasonmullett.com. All rights reserved. No portion may be reproduced without explicit written consent.