Ronnie, I do not remember, and with a little bit of experimenting you can figure it out. BUT as I recall if use SEND RECORD from [table A] which is a subset of [table A] in the receiving table this works.
issues : - field order would need to be the same (at least through the fields sent from the old system). - field data types probably have to match - as Chuck said, Record keys might be an issue depending on what/how the internal keys were designed. Keys: -if you used UUIDs (unlikely, but not impossible, in v13) then no issue - if you used longings (most likely) then you probably end up with duplicated keys for different data., and you will need some way to determine what to do with the duplicated key data. -- look for other identifiers to determine if the 'old' data is duplicated --- if not duplicated generate new keys, and save --- if duplicated - what to do? that is a business process decision and will likely need to be take up with the owners of the data. If I remember incorrectly and SEND/RECEIVE RECORD fail if the strutter is at all different. Then writing an export/import will be needed. You will still need to watch the key issue above. If you want/need, I can send you a v13 component that includes a record export to text. let me know off list. Chip On Tue, 30 Apr 2019 14:53:26 +0800, Ronnie Teo via 4D_Tech wrote: > Hi All, > > A client has requested to decommission a v13 database and merge the > data into a separate v15 database. > The 2 database structures started the same (as in same tables and > fields) but has expanded in different directions down the years. > It would be fair to say that the fields in the v13 structure would be > a subset of the v15 structure. > > A send/receive record option would not be feasible. > Tinkling with some ideas, perhaps exporting table data to CSV file > (from v13) and import into v15. > Or perhaps just exporting individual tables (individual) fields to > text files with custom delimiters…. > > What would be the best way to accomplish this? > > Regards, > Ronnie > Tarawerkz > > ********************************************************************** > 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] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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] **********************************************************************
