Michael, thanks for your answers to the questions. One thing is still bothering me, I am worried that the data exchange is still so complicated. I wonder if taking a slightly different approach could make it simpler. I shall try and describe what I am thinking...
1. Incorporate the data exchange fields within the Object tables (certificate, csr, ca_certificate etc). 2. The data exchange fields would describe the exchange status with each node. 3. When a record is created in the Object tables the data exchange fields are set to a not exchanged default. 4. The data exchange routine only then needs a single query (per object type) to determin if an export is required, rather then the cross table query. 5. When the data exchange routines are run, they update the data exchange status of each of the object records. This method would not need the "Maintenance Routine" as the data exchange status is always kept with the object. Am I missing something or being stupid in pushing this ? Chris... ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ OpenCA-Devel mailing list OpenCA-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-devel