It is possible, but not automatically, and there are a couple of options available. It also depends on how the data is structured.
For any interaction, you'll need to pull the data from the remote machines to the machine you'll be working on. (Do not access the files remotely while there is even a small chance that the remote computers will access the database -- Corruption can occur) The choices you have at that point are: 1> Copy the tables in the 'now-local' databases into a new database using SELECT * FROM DB1.T1 INTO NEWDB (Or some variation of that) 2> Use the ATTACH mechanism to pseudo-join all the databases together then run the required selects. (Note a VIEW will not work). Once you have either setup, you can build your queries around that. The issue with taking two distinctly different sets of data is data collision. If any of the tables in the two files contain primary keys that overlap, you'll need to come up with a mechanism to ensure that all Foreign Key relationships work. That'd mean looking at individual rows, and their relationships. On Tue, Jan 10, 2017 at 7:08 AM, rmroz80 <rmro...@o2.pl> wrote: > Good morning I have one question with sqlite database files. In my > company (school) there is an application called SIO (System Informacji > Oświatowej - Educational Information System). This program is running on 2 > independent computers. Each program has own sqlite file called SIO2.sqlite > and data are written separately on each machine. Few days ago my boss, ask > me is this possible to join data from two systems and create one file > containing data from both computers. Data files containing various > information about our school like: names, surnames, adressess and > equipment. Some data are on comp1, some on comp2, and now it is work for me > to create 3 comp containing data from 2 and 1. Sorry for my weak English, > because my native language is Polish. Thanks in advance Rafał Mroziński > _______________________________________________ > 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
