On Wednesday, 29 July 2020 19:09:24 BST Bernard Peek via GLLUG wrote: > That's a problem but it's manageable. If your data comes from multiple > tables you do need to understand the relationships between them. You also > need to understand the difference between tables and queries/views and the > terminology used by both databases. Check which tables have indexes. Check > whether the system you are extracting data from enforces any validation or > business rules. That might be handled by code in data-entry forms. > > I recommend importing raw data and adding keys and indexes afterwards. You > may well find that adding those rules generates errors. If you get an error > it's almost certainly because you haven’t understood the data. >
Thanks for the advice, forwarded to Rosco. -- Chris Bell Website http://chrisbell.org.uk -- GLLUG mailing list [email protected] https://mailman.lug.org.uk/mailman/listinfo/gllug
