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

Help | Advanced Search

SQLIdl v1.0

Author:	ABIdeal.com
Platform:	Windows (all)
Price:	$10
Submitted:	06/07/2004
File Size:	421 KB
Downloads:	207
Rating:


	Download

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

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!!!

If you like SQLIdl, please buy ($10 only).

More products from the author:

WinXCopy - WinXCopy is a Fast XCopy like command line tool (w...

See also:

Pabx Billing System and H... - Compatible with any PABX, 42 bills for Pabx Billin...

MicroOLAP Database Design... - Visual development system for MySQL database desig...

Recovery for SQL Server - Recovery for SQL Server recovers corrupted MS SQL ...

Advanced Access Repair - Advanced Access Repair is a powerful tool to repai...

CDB Database Comparator - ODBC-based tool for comparison and synchronization...

Barcode UFL for Crystal R... - Barcode UFL (User Function Library) for Crystal Re...

WDReportGen - WDReportGen is a report generator for Microsoft Wo...

FreshOutline - Useful data manager that helps you to organize you...

Advanced DBF Repair - Advanced DBF Repair is a powerful tool to repair c...

Cornolius Database Applic... - A secure multiuser database creator and manager pr...

Ezy Data 2000 - A Stand-Alone Database Application

SQLDiffer - Data comparison tool to visually compare two datas...

DataFavorites - A stunningly simple and convenient way of accessin...

Dator - Dator is a powerful information management program...

Navicat (MySQL Front end,... - Navicat 2004 (MySQL Client Tool) from PremiumSoft ...

DTM Data Generator - Intelligent test data generator for database testi...

DTM Migration Kit - Migration Kit is a powerful yet simple data import...

DTM SQL editor - Set of powerful database management tools: ODBC su...

AGILITA-Client - Database application development with automated Co...