SQLIdl is a Universal Web based Command Line Database (SQL) Tool

Features:

- Execute SQL Commands (DML/DDL)

- Invoke from Windows Start-->Run (command line)

- Connect any database by changing the connection string at run time. Tested databases are:

- Oracle

- SQL Server

- Preconfigure settings, so that you need not bother about typing in everytime:

- Connection string (Database, username, password)

- Frequently used SQLs

- SQLs for retrieving table/view/trigger/stored procedure definitions

- DML commands like Insert/Update need a password for preventing tampering

of database opened up using this utility. This Password is configurable (default: mypwd)

- Generation of Insert/Update command based on query results.

Retrieve from Oracle and insert/update into SQL Server or vice-versa

as it is or after typing in changes visually!!!

- Multiline data can be retrieved, changed and updated back

- Works fine with CLOB/LONG types

- Use multiple statements separated by semicolon!!! For ex: select * from dept;select * from emp

Requires .Net Framework (I use v1.1), MDAC 2.6, Internet Explorer (IE 5.5)

Installation and usage:

After installing to a IIS Virtual Folder, open Web.config from the Virtual folder and change the key conStr_def to point to your database. Please change other values if necessary.

open IE and type in as follows:

http://localhost/SQLIdl/SQLIdl.aspx

You would need to provide the correct virtual folder if you changed it during installation. Type in your SQL query and enjoy!!!

To install the command line utility, simply copy the two files SQL.exe and SQLIdl.ini to your workstation windows system32 folder, open SQLIdl.ini in notepad and provide the correct path to IIS.

Now just invoke run from Start Menu, type in your query as follows :

sql 'select * from dept'

It is THAT simple!!!