Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Creating & Restoring data from BackUps
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement