I think this is due to UUIDs for each table. even though you renamed table [Data_61] to [Data_61_x] the uuid is the same, and probably the upgrade processes the table(s) by uuid not table name.
the only solution I can think of (off the top) would be to: - export from the old system the data in [data_61] (and others) and import into upgraded version basically as Chuck suggests On Fri, 15 Jun 2018 01:36:23 +0100, Pat Bensky via 4D_Tech 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:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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:[email protected] **********************************************************************
