At 12:08 PM +0000 3/13/03, Robert Mills wrote:
>I'm looking for a better way of listing the structural differences between
>two databases.
>
>Currently I'm using our database tool (FlexiBase) to generate a schema for
>both databases and then using Allegro's SCOM utility to compare the two
>schemas. One problem with using FlexiBase is that it adds loads of comments
>that have to be removed before the comparison is done (displays loads of
>incorrect differences otherwise).
>
>Does anybody have a better method that does not require any manual editing?
Adager includes, in its contributed library group, Allegro's DBHTML
program, which generates a "lean" schema (Adager-generated schemas may
be as verbose as Flexibase's, because I am sure we both want to be extra
helpful -- a friendly "attitude" which, for your current purposes, happens
to be more of a hindrance).
I'll be delighted to send you a DDS tape (or to prepare an Internet
download at Adager's site) for your convenience -- at no charge, of course!
Here is the documentation:
:run dbhtml.library.rego
Welcome to DBHTML (version 960721)
Copyright (c) 1996 Allegro Consultants, Inc.
Authors: Stan Sieler ([log in to unmask]) and Charlie Rand ([log in to unmask]).
For help, type: HELP
DBHTML: help
(Help updated: 96/07/21)
DBHTML is a utility to display the schema for an IMAGE database
in either DBSCHEMA syntax or as an HTML file.
Commands:
DO [prefix]
If a prefix is specified, finds the more recent redo line
that matches the prefix and re-submits it. If no prefix is
specified, the most recent input is re-submitted.
Exit
Terminates DBHTML.
Help [command_name_prefix]
HELP <cr> displays the entire help text.
HELP H displays help for all commands starting
with H.
HTML basename [filename] [DELETE]
Generates an HTML page describing the specified database.
If filename is omitted, output is sent to $STDLIST. By
default, if an existing file with the same output name
exists, the command is aborted. The DELETE option tells
DBHTML that it should purge any existing file with the same
name.
LISTREDO
Lists the REDO stack, which persists across runs (while in
the same session or job).
REDO [prefix]
If a prefix is specified, finds the more recent redo line
that matches the prefix and presents it for editing and
re-submitting.
If no prefix is specified, the most recent input is
presented for editing and re-submitting.
The editor used by REDO is QZMODIFY. Pressing ^W and then
H will result in help information.
RESET <DBHTML_flag> [...]
See SET
SCHEMA basename [filename] [DELETE]
Generates a DBSCHEMA-style output describing the specified
database. If filename is omitted, output is sent to
$STDLIST. By default, if an existing file with the same
output name exists, the command is aborted. The DELETE
option tells DBHTML that it should purge any existing file
with the same name.
SET <LP | PAGING> [...]
Turns on the specified option(s) or flag(s). The state of
all options/flags is reported at the end of the SET (or
RESET) command. To see the options and flags without
changing any of them, enter: SET
SET LP routes all subsequent output to the printer instead
of to the terminal. RESET LP cancels this.
Syntax note: where multiple parameters are optional, commas are
needed to indicate omission of a parameter if you want to specify
subsequent parameters.
-------------------------
Cordially,
_______________
| |
| |
| r | Alfredo [log in to unmask]
| e | http://www.adager.com
| g | F. Alfredo Rego
| a | Manager, R & D Labs
| d | Adager Corporation
| A | Sun Valley, Idaho 83353-3000 U.S.A.
| |
|_______________|
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|