RE: dbdiff2 1.2

> > From: Jack Parker <jparker@hpbs3645.boi.hp.com> > > To: informix-list@rmy.emory.edu (Informix Users Net) > > > I've just wrapped and sent the current version to Walt. 1.2 adds in the > > two patches previously posted as well as a few other things. In sum: > > Current version of what? > I just got back onto this list, and must have missed an earlier > discussion. > > > I will not post it to the group given its increasing size. But feel free > > to ftp it from the archives. I'm still working on supporting syscolauth, > > although I suspect that it is less vital than systabauth. > > Where are "the archives"? Ummm, errr - why do I always assume that everybody in the world has been in on my thought processes from the beginning? For those of you who just tuned in - select portions of the readme file: :dbdiff2 generates SQL to bring one version (-nd) of a database in line with :another (-od). Please be careful with the SQL generated. This program has :been tested - but not exhaustively. Don't run the SQL blind - look at it and :check it first. This pgm is placed in the public domain without any :warranty whatsoever. If you use it and it trashes your database - then you :should be more careful - but it is not my problem. : :The purpose in offering this code is to allow y'all to find the bugs for me. :So be sure to let me know what goes wrong eh? : ~~~~~~~~~~~ boring history stuff removed. ~~~~~~~~~~~~~~ :------------------------------------ :Syntax: : :dbdiff2 [-db SE|OL] engine type - SE or Online (Online=default) : : If either of the two engines is an SE engine then use -db SE : since it will not support the online specific code. : : -od old database name : : This is the database you are using as the model. : : -nd new database name : : This is the database you are generating code to alter. : : [-o] output file name (default = /tmp/mod_db.sql) : : Self explanatory. : : [-a] Authority tables (permissions) : : Will generate code to bring table permissions in line : with the '-od' database. (In the future this switch will : also correct column level permissions as applicable). : : [-u] Users : : Will generate code to bring user permissions in line : with the '-od' database. : : [-s1] Only do segment 1 : : Only unload the files from -od. This option is meant for those : who cannot connect to two databases within the code. : : [-s2] Only do segment 2 : : Proceed with generation of code. This presumes that dbdiff2 : has already been run with the -s1 switch. : : [-dbg] debug mode on : : Currently dbdiff2 is quiet unless it runs into a synonym : which points to another server - in which case it will : ask you if you wish the new database to point to a different : server. -dbg displays status messages as the program rolls : along. : : [-t] table name specification : : Like it sounds. -t table will generate code for ONE TABLE : ONLY - where applicable. It may also be used as a wildcard, : e.g.: : -t 'prefix*' : or : -t '*suffix' : : [?] usage : : Generate a brief explanatory message. As for the archives (from a post by Walt some time ago): :Anonymous FTP Archive for Informix Files : : :An archive of Informix-related files and selected past messages from the :Informix mailing list and the Usenet newsgroup comp.databases.informix is :available for anonymous FTP. : :The kind folks at mathcs.emory.edu have allocated a segment of their ~ftp for :the archive. The system's full domain-style name is emory.mathcs.emory.edu, :and its IP address is 128.140.2.1. Note that this is not the same system as :the home of the Informix mailing list. The directory of interest is /pub/informix/ I hope I have told you enough without boring you silly. Holler if I failed. cheers j. ____________________________________________________________________________a Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| With friends like these jparker@hpbs3645.boi.hp.com | who needs enemas? (208) 396-5388 (W) (208) 384-1623 (H) | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________