Hi Mike, thanks for the reply. Yes, in my scenario, the size of the data file is much smaller, less than 10GB.
So I should think an export/import by table would be the approach. The slight complication is that a couple of the main tables have many subtables….one of them alone has 40+ subtable fields. So my export/import routines would have to handle that. UUIDs would be crested and saved with the records during the import into v15. Perhaps I can also consider to convert the v13 structure to v15, synchronise the field order/type, then use Send/receive record. Regards, Ronnie Tarawerkz > On 1 May 2019, at 3:00 AM, 4d_tech-requ...@lists.4d.com wrote: > > Date: Tue, 30 Apr 2019 12:42:35 -0400 > From: Mike Beatty <mikebeatty.li...@gmail.com > <mailto:mikebeatty.li...@gmail.com>> > To: 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com> > Subject: Re: Data Merge from v13 to v15 > Message-ID: <668050ce-59e3-4274-ae49-4168ee331...@gmail.com > <mailto:668050ce-59e3-4274-ae49-4168ee331...@gmail.com>> > Content-Type: text/plain; charset=utf-8 > > Ronnie- > > I often work with datafiles in size greater than 100GB, so please take that > into consideration of your needs — small datafiles might not need as > extensive an effort. > > Based on my experience, I would highly recommend you use the sql export/sql > import routines — they are the most efficient, assuming there is no level of > data manipulation. > > In the event there is any need for data manipulation (change in field > order/data types, update UUIDs, etc.), then your best bet will be to create a > generic series of routines that will allow you to monitor the export and > import routines on a table level basis. > > > HTH, > > Mike > > Mike Beatty > Objective Systems ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
