lundi 21 décembre 2015

insert 100 million records from access database to sqlite

I have an access database holding 100 million records. I am looking for the best way to insert the data from the mdb to an sqlite database using C#.

My current approach is to read the data in a datatable in batches of 500,000 and insert them to sqlite. But this takes hours for such a huge database.

Please help

Aucun commentaire:

Enregistrer un commentaire