Fastest way to migrate from sql server to sqlite for large datasets

c# .net sql-server sqlite data-migration
Sawan picture Sawan · Jun 9, 2012 · Viewed 17.9k times · Source

I have a database with more than 32 million records, I have to migrate it from SQL Server to Sqlite.

I have tried SSIS (SQL Server Integration Services) with the help of this article http://dbauman.blogspot.com/2009/03/connecting-to-sqlite-through-ssis.html

but the process is very very slow, how can I migrate this data?

Answer

Damith picture Damith · Jun 9, 2012

There is a C# utility to automatically do conversion from a SQL Server DB to a SQLite DB by liron.

Here is the code project article.

Related questions

C# Equivalent of SQL Server DataTypes

For the following SQL Server datatypes, what would be the corresponding datatype in C#? Exact Numerics bigint numeric bit smallint decimal smallmoney int tinyint money Approximate Numerics float real Date and Time date datetimeoffset datetime2 smalldatetime datetime time Character Strings …

Read More
What is the equivalent of bigint in C#?

What am I supposed to use when handling a value in C#, which is bigint for an SQL Server database?

Read More
C# equivalent of the IsNull() function in SQL Server

In SQL Server you can use the IsNull() function to check if a value is null, and if it is, return another value. Now I am wondering if there is anything similar in C#. For example, I want to do …

Read More