Subject | Querying between databases |
---|---|
Author | |
Post date | 2016-01-30T14:35:13Z |
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.