I have many separate database files that have all the same structure, but hold data from different customers. In each database, I have a series of tables that are used to supply valid values through foreign keys. These tables and the data they hold are exactly the same in each database. When I need to update a valid value in one, I have to make that same change in all the other databases. Is there a way to keep the valid value tables in a separate database and build queries that access these tables from a second database? The goal is the have a single set of valid value tables, instead of multiple copies.
[firebird-support] Querying between databases
[email protected] [firebird-support] Sat, 30 Jan 2016 06:35:35 -0800
- [firebird-support... [email protected] [firebird-support]
- Re: [firebir... Dimitry Sibiryakov [email protected] [firebird-support]
- Re: [firebir... setysvar [email protected] [firebird-support]
