Copy or Archive to a separate FM file!

[MikeRoberts]

Hi All - My 1st post here.

All I am trying to do is setup a script which copies the whole record (with all of its field contents) to a replica database for achive purposes. Is there an easier way than sending over each field separately?

Thanks

Mike

[hayesk]

You could make a script to do this:

- Find (find only this record, use it's unique id)

- Go to other db (leave this db open!)

- Import records from first db. (as long as the first db is still open, it will only import the found set of records, which is only one)

- Go back to first db.

- Delete record (if you wish)

You could also expand this with an "archive" field. Mark records as "archive" throughout the day, then at the end of the day find all archive records, import them, and delete the records from the first db. If you don't want to delete them, you could set a second field "already archived" so they don't get archived more than once.

[MikeRoberts]

The import records from 1st DB could not complete as the database is in use by FM server. I have got around it by making a script which exports all records from 1st DB to a file and then runs an external script from the 2nd DB which imports the same file. This seems to work for now

Ta