View Image

The SQLRunner is a tool to work with databases and SQL. It has various features to help a Java developer to develop SQL code and to integrate this code seamlessly in existing Java classes.

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
· 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
· Upload and download binary data in BLOB fields
· Load and execute cascaded scripts (cascaded loading and executing using the start command)