Is there anyway to modify a database structure and merge data into it after that changes been made?

Discussion created by rlhyde on Aug 18, 2012
Latest reply on Aug 21, 2012 by wimdecorte

I have been asked to make massive changes to a database that a company is currently using on a day-to-day basis. I want to take the database to my office and make the changes there. However, during the weeks or so that I will be working on it, the people back at the client will be adding data in making changes. Is there a way that I can make changes to the database structure and then move the data into the new database structure?