SQLRunner 9.5

An easy to use JDBC client
SQLRunner - Here you can visualize the contents of an SQL file.
  8 Screenshots
SQLRunner is a simple, easy to use JDBC Client designed to help Java developers with various methods.

You can build, test and run select, update and DML statements (also callable statements with out put parameters) and export or import data in/from CSV-files or XML-files.

Main features:

  • Use JDBC (Java Database Connectivity minimum JDBC 1.0 spec is enough)
  • Shipped with a large number of preconfigured JDBC drivers
  • Works with host based database like Siemens SESAM
  • Keep all your connections (with passwords optional) for direct access in login dialog and give them clear names
  • Explore the data model for all connections
  • Compare schemas and create modeling statements to update the target schema
  • Import flat text files as well as Excel spreadsheets (xls, xlsx)
  • Use batches for high performance imports
  • Explain-Function (if database provide this feature, currently implemented only for PostgreSQL and Oracle)
  • Gather source code for procedures and views (if database provide these features, currently implemented only PostgreSQL and Oracle)
  • Export a query without collecting all datasets within the memory
  • Import all tables from a schema
  • Export all tables from a schema
  • All imports and exports can run parallel in multiple instances
  • Run SQLRunner in Linux, Mac OS X and Windows as a local installation or via Java Web Start technology
  • Generate code for Java/PHP from your tested statements and vice versa extract pure SQL from a larger selection of Java code containing the SQL as string
  • Run stored procedures with in/out parameters
  • Run prepared statements with in/out parameters
  • Use a large list of useful preconfigured SQL to administrate your database
  • Sort your retrieved datasets without repeating your select statement or create a select statement for this kind of sorted result set
  • Toggle the result table orientation to see all columns of all datasets in a single column (useful for large content in columns)
  • Use a comfortable full featured text editor for the field content
  • Syntax assistance using CTRL+Space key
  • Upload and download binary data in BLOB fields
  • Load and execute cascaded scripts (cascaded loading and executing using the start command)

last updated on:
August 28th, 2014, 9:12 GMT
file size:
25.1 MB
price:
FREE!
developed by:
Jan Lolling
license type:
GPL 
operating system(s):
Mac OS X
binary format:
Intel only
category:
Home \ Network/Admin
SQLRunner
Download Button

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

Rate it!
8 Screenshots
SQLRunner - This menu allows you to login to a database.SQLRunner - Some database actions can be accessed from this menu.SQLRunnerSQLRunnerSQLRunnerSQLRunnerSQLRunner
What's New in This Release:
  • Can handle binary data (update in value editor and using them as primary key).
read full changelog

Add your review!

SUBMIT