> We are going to be running parallel with a new system and I > will need to compare old versus new. Does anyone know of any > reusable code or technique that compares similar but not > exact tables and creates an exception report.
If you're talking about comparing the database schema, as opposed to the data within the tables, tools like ERwin will do this for you very easily (the Complete Compare option). On the other hand, if you don't have ERwin and would prefer not to spend $3k or whatever it is, you could simply generate the schema from each, save the schemas as text files, and use diff or Windiff to compare them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
