Icon of program: Interactive SQL

Interactive SQL for Windows

Download now

Used Interactive SQL for Windows?

Editors’ Review

Download.com staff
This application allows users to run SQL queries and commands directly from the command line, supporting batch operations.
Enlarged image for Interactive SQL
Interactive SQL 0/3

  • Pros

    • Supports batch execution of SQL queries
    • Configurable display text size
    • Supports line and block comments
    • Customizable batch separator
    • Clear configuration parameters

  • Cons

    • Database drivers are not included
    • Requires manual driver installation
    • Command-line interface only
    • No graphical user interface
Icon of program: Interactive SQL

Interactive SQL for Windows

Download now

Used Interactive SQL for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
1.0
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 98
  • Windows 2003
  • Windows 2000
  • Windows 10
  • Windows Server
  • Windows 8
  • Windows XP
  • Windows ME
  • Windows NT
  • Windows Vista
  • Windows 7
Additional Requirements
Java 1.6
POPULARITY
Total Downloads
3,511
Downloads Last Week
3
Report Software

Program available in other languages

Last Updated

Developer’s Description

By Nick Hristov
Run queries and SQL commands.
InstallationCopy and unzip in a folder.For Unix based OS run mkfile(./mkfile). It will create isqlc.sh, which is the start up file for the application.

Installing Database DriversCopy jar file(s) into root folder or modify DRIVER_CLASSPATH to point to jar's location and start application.

For legal reasons, Database Drivers are not supplied with the application. They can be downloaded from the links below.

WindowsUsage: isqlc.cmd [[user password] [-i file]]

Unix basedUsage: ./isqlc.sh [[user password] [-i file]]

user - database user namepassword - user's passwordfile - file containing SQL queries

When -i is used, no banner is displayed and the application exits after the batch is complete.

ConfigurationJAVA_HOME - location where JRE is installedDRIVER_CLASSPATH - location of database driver(s)CONFIG_LOCATION - location of config.properties file

Config.properties filemax_text - display size of character fieldscomment - line comments markerbatch_separator - delimiter between commandsdriver - database driver classconnString - java connect string

Example:max_text=60comment=--batch_separator=;driver=com.microsoft.sqlserver.jdbc.SQLServerDriverconnString=jdbc:sqlserver://123.456.789.007:1433;DatabaseName=somedatabase

Block comments marker is the standard /* */.

Database Drivers DownloadMSSQL Server: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774ORACLE: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.htmlSybase: http://www.sybase.com.au/products/allproductsa-z/softwaredeveloperkit/jconnectMySQL: http://dev.mysql.com/downloads/connector/j/

Download.com
Your review for Interactive SQL