Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
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 '11 at 23:15
    
There is no bulkcopy for SQLite –  bernd_k Apr 30 '11 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 '11 at 19:14
add comment

1 Answer 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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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