Mydbdiff
Utility: mydbdiff Synopsis: Compare two database schema's using diff or sdiff Author: Art S. Kagel Revision: 1.3 Comments: Requires myschema Features Version 6.25 or later (included here). Mydbdiff is a ksh script that takes advantage of an feature of myschema (-o) to acquire a schema of each database with objects ordered to ease comparison. While the myschema -o option should not be use to create a schema file for porting (as you may not be able to execute such a schema because dependencies may not be created in the correct order) a saved schema created this way can be compared to the active database schema to determine changes over time using the -f option. Release Notes: Releases 1.2 & 1.3 add new features. The new -d option allows one to specify any diff utility. The -S option allows one to specify that one or both of the comparative schemas be saved in a file in the current directory named <database>.mydbdiff. The -f option allows one to compare a live database's schema to a comparative schema previously saved using the -f option or manually generated using myschema -o. The combination of -S and -f allow for tracking changes to a single database over time.