The DBScript utility generates a SQL script based on a given database table. The script will contain an INSERT statement for every row of the table; this can be used to re-create all or some of the table's contents.
Unlike BCP (a command-line utility for performing similar actions under Microsoft SQL Server and Sybase), however, this utility does give you the opportunity to deal with a subset of the table. You may specify a SELECT statement, and DBScript will only generate INSERT statements for those rows returned by your SELECT.
Usage instructions are available if you need assistance in using this utility.
You will also need to download DBScript itself. The current version is 1.9 (July 16, 2000).
DBScript is written in Java. However, due to its dependence on ODBC, it is pretty well tied to the Win32 platform.
DBScript makes use of the Apache Xerces XML Parser software, version 1.1.2 (included in the download). This is used to parse the configuration file, which is in XML format. Please read the XMLLicense.txt and apache_license.txt files distributed with DBScript for warranty and licensing information regarding the XML Parser software and its use in DBScript.
DBScript is freeware, and is covered under the GNU Public License (the Apache Xerces XML Parser is not covered under the GNU Public License, however). If you like it, or have any suggestions, please let me know. The current list of known bugs and planned enhancements is also available.
If you are interested, the Java source code is also available for download. (If you're interested, the list of known bugs/issues/code cleanup is also available.) This includes a .jpr file for use with Borland JBuilder 3.5, but the source should be just as easily compiled using the straight JDK from Sun.
Thanks to Joel Nylund and Core Java 2, Volume I - Fundamentals (by Cay S. Horstmann and Gary Cornell), both for doing an excellent job of teaching me how to write Java code. (So if you looked at my source code and don't like it, blame them. :)
Comments or questions about this web page or about DBScript? Email me at software@eshayne.com