Re: [sqlite] Connecting DataBases files into one

2017-01-10 Thread Simon Slavin
On 10 Jan 2017, at 12:08pm, rmroz80 wrote: > 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

Re: [sqlite] Connecting DataBases files into one

2017-01-10 Thread Jim Callahan
​​ 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)

Re: [sqlite] Connecting DataBases files into one

2017-01-10 Thread Richard Hipp
On 1/10/17, Stephen Chrzanowski wrote: > (Do not access the files remotely > while there is even a small chance that the remote computers will access > the database -- Corruption can occur) Everything Stephen says is correct. I'd just like to add that the possibility of

Re: [sqlite] Connecting DataBases files into one

2017-01-10 Thread Stephen Chrzanowski
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

[sqlite] Connecting DataBases files into one

2017-01-10 Thread rmroz80
Good morningI 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