Using Backups

Discussion created by RogerAC on Mar 8, 2013
Latest reply on Mar 10, 2013 by RonSmithMD

When developing I create a backup before I start work on a database and then work on this copy.


The developing can go on for several days trying out various ideas and making copies as I go while at the same time the original continues to be worked addind data over the time of the development.


Once I have a working solution I want to import data from the live database so that it can then become the new live database.


Is it possible to import the data from the live database as a job lot from all the tables rather than have to go to each table and perform the import one at a time.


If there is a script out there that would do this I would be interesting in reading it here and for it to be fully documented showing where my tables would go in the script.


Looking forward to your replies.