Converting from one SQLite database to another may also be accomplished by
using the ".mode insert <table_name>" output format of the SQLite shell and
then SELECTING the rows according to the full target schema. This creates SQL
of the form "insert into <table_name> values (<field values>); NOTE: No field
list
Or you can SELECT 'insert into <table_name> (<field_list>) (',<field_list>,');'
from <table>; after setting .mode list and .separator "," and .out <filename>
Maybe your source database supports equivalent features that allow "proof of
concept" via scripts.
Writing your own "bridge program" to translate between yource and destination
databases is bound to be significantly faster though.
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von
[email protected]
Gesendet: Mittwoch, 20. Juli 2016 00:02
An: [email protected]
Betreff: [sqlite] SQL to SQLite
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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___________________________________________
Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: [email protected]
This communication (including any attachments) is intended for the use of the
intended recipient(s) only and may contain information that is confidential,
privileged or legally protected. Any unauthorized use or dissemination of this
communication is strictly prohibited. If you have received this communication
in error, please immediately notify the sender by return e-mail message and
delete all copies of the original communication. Thank you for your cooperation.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
