Re: How do you do database integrity?

Dave Heisler writes: -> -> ->I have a question about how to approach the ->problem of database integrity. My situation ->is this: -> ->In my group we develope on one machine, then use ->dbmerge (fourgen) to take the code accross platforms. ->We currently have 3 platforms, and will be adding 3 ->more. We have one person in charge of databse changes, and that's ->me. We (I) try to be careful but none the less, differences creep ->in. -> ->Is there a way I can verify a database is correct or otherwise ->matches another without spending large amounts of time doing so? Jack Parker's wonderful, superfantastic, amazing, and absolutely free utility dbdiff2 (or maybe dbdiff3 now?) will solve your problems for you. Have a look in the archives for this group in mathcs.emory.edu (I think that's the right name). Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (970) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (970) 491-1205