Steve,

Will changes be made to records in both systems that will need to be in sync. Is it possible that the same record be modified by both systems on the same day or is the QA database the only one updating and the Sesame is just displaying the data?

Steve,

I always try to find elegant solutions to problems but this may not be a fight worth fighting. Since your basically replacing all the data anyway it might make more sense to just replace all the data each day. At quick glance it seems much less complicated to make some kind of a routine that replaces all the data rather then append some of the data.

Quote:


That may be a different story. I did not understand the problem before. The issue is the transfer time of the data.

In that case lets think about this.
We know:
It is easy to have a field in QA to identify what records are new or modified each day.
It is easy to export just those records from QA.

If it is a relatively small percentage of all the files so that transfer of records would be considerably shorter maybe its worth thinking about creating a  routine using XPOST.

Unfortunately I know very little about xpost but on page 38 of the Sesame programming Guide   it says posts the entry value to the target element on a match between the key element in current database and the external yada yada.. default operation is Replace.

In basic terms imagine transferring the small file then
Create a routine something like this:{I am reaching here. There may be a cleaner way to use Xpost)

import data into a temporary database,  that database uses xpost to match record id in good Sesame database and it marks a field in your good Sesame database that is used as a way to identify the record for mass deletion.

Then the mass delete is ran

Then when the exported file is imported all would be in sync.

I hope that makes some sense. The key here is how much time is saved by transferring just the modified records as opposed to all the records.

Let us know if it is a significant amount of time and if it is we can learn more about xpost or ?

Robert