Database Sync in SQLite database

I have 2 sets of database one for Prod and other for reporting purpose

1. marketing
2. marketing_Report

I want my reporting database (marketing_report) to be sync everynight with production (marketing) they both are on same server. I do not want to use replication. What is the best method to do. I want to automate this on daily basis.

I can do backup and restore but is there any other way to do?