This is the track I took as well because being an OEM database, I don’t want to have to deal with mapping every single 4DD file I open up.
I’d be interested in seeing the SQL code as well, but your #2 is the best piece of advice I could offer as well. Randy ---------------------------------------------------------------------- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 > On Oct 4, 2016, at 10:49 AM, Peter Jakobsson <li...@netkelvin.com> wrote: > > > >> We’ve seen with v15 the biggest thing seems to be the unique keys, >> presumably with uuids. How did you handle that? Did you just have uuids >> added onto all your tables? > > Ah ! > > Well you can either spend 2 days doing it (as I did once)……or you can get > hold of a bit of SQL code originally posted by Ortwin Zilgen and do it in > about 20 seconds. > > The general consensus is: > > [1] - forget trying to map your old primary keys (IDs) to new ones. Keep all > your code as it is and IDs as they are > > [2] - create new UUID primary keys for every table and let 4D have control of > them. You keep control of the old ones (which are now demoted to ‘business > logic’ layer primary keys) > > In principle therefore, the new UUIDs basically work like the old record > numbers except they’e now just saved into the record. I’ve done this in a few > databases and it’s the most transparent way - basically no thought required > and lets you sleep well. > > I’ll see if I can dig out that piece of SQL code… > > Peter > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://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: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************