5

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.

EDIT:

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.

3
  • I can only imagine a bulk copy would be the best bet... that sounds like a lot of work, why not just do backups of the databases?
    – jcolebrand
    Commented Apr 29, 2011 at 23:15
  • There is no bulkcopy for SQLite
    – bernd_k
    Commented Apr 30, 2011 at 6:50
  • I meant the concept of reading a bunch of rows into a reader format and then writing them back out. Like using a datatable in C# or the like
    – jcolebrand
    Commented May 1, 2011 at 19:14

1 Answer 1

1

I have successfully used SQL Server Integration Services (SSIS) to setup a job to "archive" data to SQLite databases. A quick way to build a SSIS job, is to do a Task->Export Data task. At the very end you will see a checkbox on the top left asking you if you want to save this as a SSIS job.

Make sure that you have installed the SQLite provider from http://sqlite.phxsoftware.com/

You can schedule this SSIS package once it is saved.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.