Interactive SQL for Windows

Name: Interactive SQL
Rating: 4.9 (1 reviews)
Author: Nick Hristov

Download now

Used Interactive SQL for Windows? Share your experience and help other users.

Key Details of Interactive SQL

Run queries and SQL commands.
Last updated on July 12, 2013
There have been 4 updates
Virus scan status:
Clean (it’s extremely likely that this software program is clean)

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/