Can anyone advise me on the best way to change serial numbers to UUID's without breaking any existing relationships?
I originally designed the database using auto-enter serial numbers but changed to text based UUID's when we implemented GoZync for syncing local copies on iPads etc. As the original ID fields were changed to text fields, 'finds' are unreliable as searching for 1 will find record ID 1 and 10 etc. etc.
So, I now need to change all the old ID's to UUID's and would appreciate any comments or suggestions.
FM Pro 12 Advanced