scotthutchings
Registered User.
- Local time
- Today, 15:34
- Joined
- Mar 26, 2010
- Messages
- 96
I need to replace the backend of my database with one that adds several fields to many different tables. There are currently 122 tables so the manual method is not very appealing (especially because I anticipate further additions from the client which would require me to do it again). The database is currently live so I need to transfer all the data from the existing database into the tables of the new database. I am not on site so I will be sending the client an update so I need to do it via code. How do I cylce through all of my tables and Insert all the data from my tables in one database to another? One more element is having the user that will actually perform the update point to the existing database location through a browse window?
Thanks for your help!
Scott
Thanks for your help!
Scott