Re: [Squirrel-sql-users] Request on multiple databases
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Sertic M. B. <Mir...@be...> - 2008-04-15 07:42:32
|
Hi This is not an out of the box feature of jdbc and depends on the database product you are using. For instance, if you are using oracle, you can use dblinks... Regards Mirko -----Ursprüngliche Nachricht----- Von: at...@bl... [mailto:at...@bl...] Gesendet: Dienstag, 15. April 2008 09:37 An: Sertic Mirko, Bedag Betreff: RE: AW: [Squirrel-sql-users] Request on multiple databases Hello, I mean multiple database connections on multiple machines (or one local, one distant). For instance, if I have to combine information coming from different databases (on different machines), or for putting some information from one database into an other one (INSERT or UPDATE). I work with MySQL and FileMaker (via Server Pro) databases. Many thanks Francesco ----Message d'origine---- De: Mir...@be... Date: 15.04.2008 09:18 À: <at...@bl...> Objet: AW: [Squirrel-sql-users] Request on multiple databases Hi Do you mean the same database connection and select data from different schemas, or in fact multiple database connections on multiple machines? Regards Mirko -----Ursprüngliche Nachricht----- Von: squ...@li... [mailto:squ...@li...] Im Auftrag von at...@bl... Gesendet: Montag, 14. April 2008 19:59 An: squ...@li... Betreff: [Squirrel-sql-users] Request on multiple databases Hi, Is it there a possibility to combine tables from different databases (opened under different Aliases) in a unique SQL statement ? In MySQL, you would use the clause FROM db_name.tbl_name. Which is the Squirrel SQL syntax (if there is one) ? Many thanks for your help Francesco Beretta (Switzerland) ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |