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
Operations

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:
Depend
 

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
"fb://sysdba:pass2@anotherhost/opt/firebird/hr.fdb"

create database link system as
"ib://sysdba:masterkey@192.168.1.99/C:/Interbase/system.gdb"

create database link vbulletin as
"mysql://vb:vb@localhost/vbulletin"


create database link compiere as
"oci://compiere:comp@192.168.1.159/ORCL"


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

 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.