1. 

   mfiorentino, Member

   Hi,
   I need to run a query that accesses two different databases on two different servers. is it possible? I have to buy a new license?

   thanks
2. 

   myDBR Team, Key Master

   Hi,
   what is the database system you are using?

   --
   myDBR Team
3. 

   mfiorentino, Member

   mysql

   thanks
4. 

   myDBR Team, Key Master

   Depending on complexity of the needs, you can use Federated storage engine, replication or use another myDBR instace with myDBR's Remote servers-functionality.

   --
   myDBR Team
5. 

   mfiorentino, Member

   since I do not have much time to configure replication I prefer the 3 option (use another myDBR instace with myDBR's Remote servers-functionality). I just change the current one or do I have to buy another one with this characteristic? Can you tell me the costs and the link of the purchase? Thanks
6. 

   myDBR Team, Key Master

   The remote server feature is included in the Premium and OEM licenses available from https://shop.mydbr.com.

   --
   myDBR Team
7. 

   mfiorentino, Member

   already i have premium licence for 1 server. i need to buy another premium licence for 2 server?and then how can i connect two servers and use myDBR's Remote servers-functionality.

   thanks
8. 

   myDBR Team, Key Master

   Yes,
   the second server needs it's own license.

   See the link above to the documentation how remote servers. Basically you call a report in remote server and get the results back to your local server where you can combine the data with the local data.

   --
   myDBR Team
9. 

   mfiorentino, Member

   ok thanks

Reply

You must log in to post.