Thanks for your response. Programming language is definitely the way I want to go, and in fact I programmed a workaround, but I assume I took the long way around and that there's a more standard way to do it.
Any SQLite string is going to refer to just one database, so you can't write an INSERT command that will take from one database and write to another, or can you? How would this normally done? -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.A. Nagy Sent: Tuesday, July 19, 2016 3:32 PM To: SQLite mailing list Subject: Re: [sqlite] SQL to SQLite 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users