SQLRunner

A JDBC client to assist you with your development.
Download

SQLRunner Ranking & Summary

Advertisement

  • Rating:
  • License:
  • GPL
  • Publisher Name:
  • Jan Lolling
  • File Size:
  • 21.7 MB

SQLRunner Tags


SQLRunner Description

SQLRunner is a handy, simple 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 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)


SQLRunner Related Software