I have a database with about 50 tables with use together about 1 GB space. The SQLite database will be readonly. This copying will be done once each month.
I see one possible solution using linked server via SQLite 3 ODBC Driver which results in rather simple t-sql scripts. I don't know about its performance.
I guess that other solution require more work, but obtain better performance.