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

Question

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 1

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.