4 Replies Latest reply on Mar 10, 2013 7:19 AM by RonSmithMD

    Using Backups

    RogerAC

      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.

       

      Playbyte