Hi Pat, I started using Export/import sql to compact/move data between versions since v12, and I remember having issues with certain versions of v12 when the exported fields contained single-quotes in that they were not escaped correctly. If I remember correctly, it was fixed in late v12 versions (v12.6?). Also, I had to make sure I hadn't renamed any tables/fields.
On Mon, Aug 20, 2018 at 11:22 PM Pat Bensky via 4D_Tech < [email protected]> wrote: > I'm exporting data from a v12 database using EXPORT SQL and importing it > into a v16 database. > For the most part this works OK, but in some tables, records are missing. > I can't see anything consistently different or wrong within the missing > records. > > All text fields are stored within the records. > > Anybody have any ideas about this? > > -- > ************************************************* > 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) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- Nils Kollandsrud Ixmal Intelesis AS, Pilestredet 75 C, Postboks 5130 Majorstuen, 0302 Oslo, Norway Tel: +47 22121212 Mob: +47 920 15550 ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
