>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?
COPY FILE, XCOPY, WSH or API should work much faster.
>
>Thanks.
>
>Ria
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)