Thanks R.A.Nagy. Would you be able to provide a quick example of what you mean?
What I ended up doing was iterating through the rows and columns of the SQL database and creating a string that would later be used as an SQLite Insert command. Seemed like that was the long way around. If there's a way to construct a command that in one step takes from one SQL database and writes to a SQLite database, I'd like to see an example of that syntax. Thanks. -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.A. Nagy Sent: Wednesday, July 20, 2016 7:25 AM To: SQLite mailing list Subject: Re: [sqlite] SQL to SQLite 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
