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