Fastest way to migrate from sql server to sqlite for large datasets
.net, c#, data-migration, sql-server, sqlite
Solution
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.
Problem
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?