Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MSSQL guid Data type converting to SQLite

Posted on 2015-01-26
1
Medium Priority
?
312 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
1 Comment
 
LVL 25

Accepted Solution

by:
chaau earned 1500 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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

885 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