Thank you all for your feedback. I now have a lot more to digest. I
will investigate the attach command. I am concerned about keeping all
of my company's data in 1 file, as if something happened to that file, I
would have data entry, programming, etc. to on all systems since the
last backup, not just 1. That might cause a day's worth of 'business
interruption'.
On 08/31/2017 07:15 PM, Keith Medcalf wrote:
Now, there are some unusual situations where you might want to hold
your customers in a different database from your invoices and use
SQLite to hold both databases open at once using ATTACH. I’ll let
other people argue about that.
But of course if you do that, then you cannot have the database enforce
referential integrity and you have to do it yourself.
_______________________________________________
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