Thread: Joining tables from different relational databases with AlligatorDBC

Joining tables from different relational databases with AlligatorDBC

From
webmaster@alligatorsql.de (www.alligatorsql.com)
Date:
Hello everybody,

with AlligatorDBC (database connectivity) you are able to join table from
different relational databases f.e.
a table in MySQL mytab and a table in Oracle oratab

This works for Oracle8i, MySQL, Interbase, Birdstep RDM, PostgreSQL and MSSQL.

Select * from oratab, mytab where oratab.id = mytab.id

Export and Import from f.e. MySQL to Oracle

Create table oratab as Select * from mytab.

If you need information just send us a e-mail to info@alligatorsql.com
We will send you an article about the AlligatorDBC/SQL and the techniques.

Hope that helps ?

Best regards
Manfred Peter
(Alligator Company GmbH i.Gr.)
http://www.alligatorsql.com