Synchronize data from sql express to sqlite
(1) By avsqlite on 2020-11-01 01:36:40 [link]
Hello, I have to do the following activities: 1. replicate the database from Microsoft sql express to sqlite 2. update sqlite, every hour, with the changes of sql express. Are there any tools to do this? Best regards.
(2) By Simon Slavin (slavin) on 2020-11-01 08:52:31 in reply to 1
Yes. Your favourite programming language. The SQLite Command Line Shell can be scripted to import data from CSV format. You may find an equivalent tool for your other database system which can export data into CSV format. And then write a script or program to do one, then the other.