tnsgen - Test Data Generator

Tnsgen is a freeware test data generation tool which runs under Windows, Solaris, HP/UX and Linux and offers a tremendous degree of control in the format of the generated data and allows input data to be derived from input data files in CSV format, enumerated values within a script file or from internal functions that provide random or sequential generation of numbers or dates. Tnsgen also supports random generation of specialized data types, including Canadian Postal Codes and Canadian Social Insurance Numbers and several types of randomized text, including "greeked" textual output. The Tnsgen package includes "seed" data for such common attributes as Names, Addresses, Canadian and US Cities, Provinces, States, Area Codes, Stock Symbols and more. Any data set may be easily created and added to allow virtually limitless data generation.

Tnsgen Home Page

SchemaScanner is a Java/JDBC tool designed to assist developers and DBA's in examining and understanding Oracle database schema's and database contents. SchemaScanner automatically scans an Oracle database and verifies that the database design conforms to generally accepted design principles and samples the attributes of all specified entities to determine basic data mining elements, including uniqueness, percentage null and data variance. SchemaScanner produces an XML output file which can be formatted using supplied XSL output formats to generate a reverse-engineered schema, an attribute usage profile or document schema structure exceptions . Since the output format is well-formed XML, custom reports can be easily constructed from the generated XML file using XSL.

SchemaScanner Home Page

SchemaDiff - Oracle Schema Difference Analyzer

SchemaDiff is a Java/JDBC tool designed to assist developers and DBA's in examining and understanding the difference between two Oracle database schema's. SchemaDiff automatically scans the two Oracle schema's using JDBC and produces an XML output file which can be formatted using supplied XSL output formats to generate a schema difference report. Since the output format is well-formed XML, custom reports can be easily constructed from the generated XML file using XSL to perform tasks such as automated schema migration.

SchemaDiff Home Page    Coming Soon!