Multi-database Applications
Go Up to Application Development
Unlike many relational databases, InterBase applications can use multiple databases at the same time. Most applications access only one database at a time, but others need to use several databases that could have the same or different structures.
For example, each project in a department might have a database to keep track of its progress, and the department could need to produce a report of all the active projects. Another example where more than one database would be used is where sensitive data is combined with generally available data. One database could be created for the sensitive data with access to it limited to a few users, while the other database could be open to a larger group of users.
With InterBase you can open and access any number of databases at the same time. You cannot join tables from separate databases, but you can use cursors to combine information. See the Embedded SQL Guide for information about multi-database applications programming.