Re: Comparing two tables

Thanks, but we need to record the differences and then apply changes to the second environment. It does seem unanimous that the diff is faster than anything you can do in INFORMIX. It may not be practical in your case, but on a unix system you COULD unload the two tables and run diff against the ascii files. Assuming of course the schema of the tables are identical. rc } Does anyone have code to compare the data in two different tables, or } comments on } the most efficient way to do this? } } } } } } } } Hello, } I need to compare two different databases and I've downloaded 'schemadiff' } from the IIUG. } Does anyone knows how it works? Or knows about a better solution for } comparing two databases? } } Thanks in advance } Serafim Fonseca } ========================================================================== } Serafim Fonseca e-mail: sf@growela.pt } Growela Portuguesa Calcado, Lda. phone : +351 2 9866300 } S. Pedro Avioso, Castelo fax : +351 2 9812212 } 4470 Maia - PORTUGAL } } } } }