I need to convert an MSSQL db into SQLite. One of the fields in MSSQL has a data type of 'uniqueidentifer' which is a guid.
When I convert this db into SQLite there is not data type guid. I need to maintain the references across many tables all of which have guid's as the primary key.
There are 55 tables to deal with. All relating to each other via the guid's
Any suggestions on how to handle this? (I am writing the code in C#)