Solved

MSSQL guid Data type converting to SQLite

Posted on 2015-01-26
1
231 Views
Last Modified: 2015-02-10
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
0
Comment
Question by:RonWensley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 25

Accepted Solution

by:
chaau earned 500 total points
ID: 40571973
SQLite does not have many special datatypes. In fact, there are only five datatypes. There is no even a date datatype and there are two different options for storing them. D. Richard Hipp recommends using the ISO standard, and I tend to agree with him, as it is sortable and human readable.

As for your problem - use TEXT (which is a synonym of a VARCHAR/VARCHAR2 datatype in SQLite). You do not even need to specify the size there, but if you insist then use VARCHAR(16)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question