Can you be a little more specific? Do you want to look for changes in the schema or changes in data between two versions?
If you want to look for schema changes, you can query the data dictionary if the schemas are on the same instance. If you want to look for differences in table data, it gets a little more complicated as you then need to find some way to visualise the data. I did something like this that used OLE automation to populate a spreadsheet and colour- code the data. We used it to keep track of rapid updates to a large body of reference data coming from the client (approx. 230 ref tables with 30k rows between them in a schema of 500 or so.) Unfortunately It was written for Oracle and makes some assumptions about the data model (mainly it assumes that the tables all have a primary key called 'ID') so it's probably not that useful in its current form. It's written in Python and could be modified without too much fuss. Making the PK generic would be a bit of work but writing a SAP-DB database adapter for it would be trivial. If there's some genuine interest I'll see if my PHB will let me put it up on Sourceforge. -----Original Message----- From: daveg2 [mailto:[EMAIL PROTECTED] Sent: Thursday, 6 March 2003 3:22 p.m. To: [EMAIL PROTECTED] Subject: Can I diff two databases? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
