Querying between different connections (same schema)

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
bluedev
Posts: 1
Joined: Tue 01 Jan 2019 13:14

Querying between different connections (same schema)

Post by bluedev » Tue 01 Jan 2019 13:34

Hello guys,

I've just started using MySQL dbForge and I would like to know how to query between different connections (same schema used for all of them).

Here is my situation:
  • Connection:DB1, Schema: My_schema, Table: APIKeys
  • Connection:DB2, Schema: My_schema, Table: Coupons
Here I want to do a join between these two tables, but I'm not sure how to tell to dbForge that I'm working with different connections.

Happy New Year! Wish you all the best in 2019!

Looking forward to your replies. ;)

alexa
Devart Team
Posts: 2657
Joined: Fri 24 Jun 2011 14:17

Re: Querying between different connections (same schema)

Post by alexa » Wed 02 Jan 2019 08:24

There is no such a possibility in dbForge. You can build queries only within the same connection.

Post Reply