Home  About Us  DBUtility  Programming Notes  Contact Us  Carpe Diem

DBUtility was initially constructed to provide an easier method of executing store procedures over IBM's Stored Procedure Builder. It has evolved over time to include: Scripting method to execute stored procedures Comparison/Regression testing of results from matched stored procedures or SQL across systems. Scripting for SQL Data transfer between systems using SQL DBUtility is a Java GUI. It does require the user to have: Java runtime installed (JRE 1.4.2 minimum) The appropriate relational database clients or server software Have corresponding database JDBC jar or zip files to connect to the corresponding relational database system. Download files DButility zip file containing DBUtility.jar, various other support jars and readme files DBUtility.zip Readme files (These are incorporated in the zip file) Readme.doc Readme.htm Script file to create MySQL world and world2 (same tables as world but tables will be empty) databases. MySQL world and world2.sql Script file to create DB2 versions of world and world2 databases DB2 world and world2.txt Updates: 06/13/2007 Fixed bug causing error when connecting to databases 04/08/2007 Fixed various bugs, tested with MySQL, started standardizing keywords. Updated readme files 02/18/2007 Added option to output DBQuery select statement to Microsoft Excel spreadsheet Updated readme files 01/09/2007 Added support for select/update to data transfer. Updated readme files