There are several ways to work with other databases. From the SQLite, we can always attach another file so as to work with > 1 database file at a time. From a programmatic point of view, one simply uses yet another database connection to do the same thing.
On Tue, Jul 19, 2016 at 7:21 PM, Robby Helperin <r...@spotlightmusic.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users