Surely the best way to routinely & autocratically copy a set of data from one database to another SQL technology would be to use a programming language - like Java, C/C++, C#, or Python for example - so as to copy data between two different database connections.
The only other way would be to create a textual .dump or CSV (etc) export file, then munge the data for a clear-text importation via any data migration tools available for the foreign SQL 'tech. Here is an explanation of how to do the later for SQLite: https://www.youtube.com/watch?v=bVq57NBOaLs On Tue, Jul 19, 2016 at 6:01 PM, <tm...@spotlightmusic.com> wrote: > What's the best way to Insert or Update records from a connected SQL > database to the connected SQLite database? > > > > I don't mean just once, but to do every so often. > > > > Thanks. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users