If you are into Java, then I have a source code generator that should do the trick:
https://sourceforge.net/projects/sqlmate/?source=directory All one need do is to use the main.java included in the archive to generate the DAO, then create two connection strings - one for each database file. Using JDBC one could then connect to both files, then copy one set of data using the generated code between the two database Connection()s. Easy-peasy! =) On Wed, Jul 20, 2016 at 4:48 PM, Robby Helperin <r...@spotlightmusic.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users