How about using sql to bring data from old database into new one Regards
Chuck Sent from my iPhone > On Jun 14, 2018, at 8:36 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm updating a client's database from an old version of my app, in 4D v12, > to the latest version, using v16. There have been various modifications to > the structure in between the version they are using and the current > version. Tables have been added, deleted, repurposed. The result is that > when the database is opened in the v16 version, some of the tables are lost. > > I figured out that I should be able to fix this by using GET MISSING TABLE > NAMES and REGENERATE MISSING TABLE. > > But some of the missing table names are the same as some "live" table names > in the updated structure. > So I changed the names of those tables in the old structure by adding "_x" > to each one. e.g. "data_61" becomes "data_61_x" etc. > > However, after opening the database in the updated (v16) structure, the > missing table names list shows the ORIGINAL table names, not the MODIFIED > ONES! "data_61_x" has reverted to "data_61", etc. So if I try to use > REGENERATE MISSING TABLE, nothing happens because there is already a table > with that name. > > Any ideas about this? > Pat > > -- > ************************************************* > CatBase - Top Dog in Data Publishing > tel: +44 (0) 207 118 7889 > w: http://www.catbase.com > skype: pat.bensky > ************************************************* > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************