Hi,

We have an application that is trying to fill a FoxPro database with data. The application deletes all the records from all the tables and adds new records to the tables.

Assuming that we have a backup of the database, what will be the best way to accomplish this task?

1. Restore data from BACKUP, when this app fails OR
2. Back up the new database when the app completes successfully.

Either way what I am trying to do is copy data from one database to another.

I am trying to find the quickest method to do this:

- Select * from BackUpTable1 into Table1 OR
- Use Replace OR
- APPEND FROM

OR is there a better method?

Thanks.

Ria