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.

Improve this question
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 ♦
    Apr 29, 2011 at 23:15
  • There is no bulkcopy for SQLite
    – bernd_k
    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 ♦
    May 1, 2011 at 19:14

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

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

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