Agree with Stephen and Dr. Hipp
1. Make copies of the SQLite data files when the SIO program is not in use
and without using a network -- use a USB stick or removable disk (prevent
corruption, always good to have a backup)
2. Using the SQLite command line interface (CLI)
https://sqlite.org/cli.html
use the "ATTACH DATABASE" SQL statement
https://sqlite.org/lang_attach.html
3. Again at the SQLite command line use the ".databases" "dot-command" to
verify the connection
The ".databases" command shows a list of all databases open in the current
connection. There will always be at least 2. The first one is "main", the
original database opened. The second is "temp", the database used for
temporary tables. There may be additional databases listed for databases
attached using the ATTACH statement. The first output column is the name
the database is attached with, and the second column is the filename of the
external file.
sqlite> *.databases
*
https://sqlite.org/cli.html
4. Check the schemas of the two databases with the .tables, .schema and
.indexes command
5. If the tables have EXACTLY the SAME FIELDS you can merge tables using
the procedure described in this StackOverflow answer.
Pay attention, however, the difference between UNION and UNION ALL
http://stackoverflow.com/questions/30292367/sqlite-append-two-tables-from-two-databases-that-have-the-exact-same-schema
Jim Callahan
Orlando, FL
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
