I recently added a field to one of the tables in my database. How can I transfer my existing data to the newly restructured backend?
Only 1 table has been changed to add a single new field.
I recently added a field to one of the tables in my database. How can I transfer my existing data to the newly restructured backend?
Only 1 table has been changed to add a single new field.
I would get all users out of the production back end, make a copy of it just in case, then make the change there. Then create a new front end that makes use of the new field and distribute it. An alternative I use when working with a remote client is to create a DDL query that adds the field to their back end, again after having them make a copy of it. If you really want to move data, you'd have to create an append query for every table to copy data from one database to the other.