RonWensley
asked on
MSSQL guid Data type converting to SQLite
Greetings,
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#)
Thanks,
Ron
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#)
Thanks,
Ron
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.