SQLite Forum

how best to completely replicate a db file?
Login
I think I could manually perform all the steps but I was curious to know if there is a semi-automated way to regenerate a database from a schema and a set of exported data files.

I have a case where I can't physically access the db file easily but can programmatically. For security I can download the file but I can't upload a replacement. So I'd like a scripted solution that I could use to regenerate a db file from scratch and then populate the tables with data that I know is accurate.

If there is a handy utility that takes care of the grunt work or a site that describes the steps I'd appreciate any pointers.

Thanks.