[GLLUG] Moving from a Paradox database on Microsoft to Linux

[John Winters]

On 28/07/2020 18:13, Martin A. Brooks via GLLUG wrote:
> On 2020-07-28 17:40, John Winters via GLLUG wrote:
>> Importing into any Linux database from a CSV file is easy-peasy and can
>> be accomplished in 5-10 lines of code.
> 
> That is almost certainly guaranteed not to work for any relational
> database as the relations will not be maintained.

Not true at all.  The relations are easily maintained.  Either preserve
the existing keys and references, or if it is necessary to generate new
key fields then construct an in-memory mapping between them and convert
whilst loading.

I have used the technique as described above on several occasions and it
works just fine.

John

-- 
Xronos Scheduler - https://xronos.uk/
All your school's schedule information in one place.
Timetable, activities, homework, public events - the lot
Live demo at https://schedulerdemo.xronos.uk/