How easy is it to transfer data to new DB
Hope someone can help with whats probably a very basic question.
Suppose I build an initial database containing several tables and several relationships. After several months i decide to add enhancements and update the interface a little. Instead of working on the live database i manipulate a copy of the original empty database, so it now in effect becomes v2.
Is it easy, without going into too much technical detail to transfer the data from the original database to the new version 2, maintaining all the existing relationships. Would i have to manually remap fields even if none of the original have changed or is it an automated process?
Many thanks for any help