dbdiff2

Pholks, I just sent the latest copy of dbdiff2 to walt to include in the archives. (From the READ.ME) dbdiff2 generates SQL to bring one version (-nd) of a database in line with another (-od). This release (1.4) provides support for constraints, triggers, and SPLs. There are now a WHOLE LOT OF switches instead of the many that there used to be. I recommend that you modify the proc_arg() function to default the switches to the way YOU want the program to behave and then never worry about it, rather try to figure out what all the switches are each time. --- 1.4 Beta corrections: s1/s2 switches made to work again (Cathy Kipp) Typo in incorporating triggers/procedures o_systabs should be o_systables (Kerry) Triggers and Procedures changed to use fold_and_push() column can now be added BEFORE the first existing column (Kerry) Kerry points out that fold_and_push() double spaces output and can potentially break a line within quotes. This means constraints which use the CHECK clause may mess up. Since I just changed triggers and procedures to use this routine they have the same potential problem. (double spacing has been handled, but not the quotes) Kerry also provided me with RDS versions of the three 'c' routines and the makefile. Typo line 1033 (John Fowler) log() changed to logg() (J Fowler) Makefile dependencies changed to make dialg_lib.o and lib_c.o Intervals with a precision (e.g. DAY(3) TO DAY) are now handled (jp) Defaulted Constraints, User permissions and SPLs to ON. Bug fix - when doing USER and not AUTH would crash - corrected. ---- Unresolved: SPL creation dropping core. I've spent about 6 hours on this section and can by adding a single line of code drop the core quite easily. I don't fully understand it - but have commented out that line of code. This means that the SPL loses all white space between code lines. The last SPL code I generated had one line of the SPL duplicated. I have not been able to recreate this at will yet. ---- Future (prioritized): Permissions (authority tables) ( in process - haven't done columns yet ) Support for sysdefaults. fold_and_push - constrain for quotes. non-self-excluded index prob (DROP a clustered index before creating a new one). Rebuild table option when column order is hosed. Full Support for ANSI mode Form driven option split col_cnvrt() and other generic functions off into a library so they can be used by others. ---- As always, let me know of any bugs you find and I'll attempt to address them. Please understand that this utility is not my sole purpose in life and therefore it may take me some time to get new releases out. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "Character is what you are in the dark" - Emilio Lizardo _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________