I have an application with a big database file ( + 60 GB), with 128 tables. (4D v17)
All id fields and foreign keys are of type longint. Now, for replication and sharing purposes, I would like to change the type to UID. The process seems quite cumbersome: to start, I need to remove the ‘primary key’ flag from all the ID fields, then I need to add UID fields to every table, change the foreign keys as well, and use apply formula to make sure the relations are intact. I am a bit worried that this will have a major impact on the size of the data file. Furthermore, I need to automate the whole process so the upgrade works flawlessly at the customers site. Has anyone ever done this? Any tips? Regards, Rudy Mortier Two Way Communications bvba ********************************************************************** 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] **********************************************************************
