Issue Details (XML | Word | Printable)

Key: CORE-776
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: alassiry
Votes: 31
Watchers: 18

If you were logged in you would be able to see more operations.
Firebird Core

Database Links

Created: 03/Apr/05 12:00 AM   Updated: 19/Oct/09 05:27 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Issue Links:

SF_ID: 1175710

 Description  « Hide
SFID: 1175710#
Submitted By: alassiry

It would be great if we could link databases together,
even with non-firebird databases.

for example:

create database link hr as

create database link system as

create database link vbulletin as

create database link compiere as

then you can:
select * from table1@hr h,table2@compiere c,
table3@vbulletin where h.field=c.field and

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Umberto Masotti added a comment - 12/Sep/06 02:35 AM - edited
It would be useful, as first step, to have heterogeneous queries in SQL, DSQL and PSQL between Fb databases through the same server.

I'm aware of the whole architecture must be designed before any single step in this direction, but AFAIR the whole discussion ended without drawing a clear conclusion.