Export Query_Result from Instance A to Instance B (as table or whatever)

Aymen_benk's profile image Aymen_benk posted 4 years ago in General Permalink

I have the Access to Client Production_Instance (Production) but i'm allowed just to READ_DATA.

I runned a Query on Client_Instance (Production Akeneo-3) and need to save/export the Query_result (SELECT) to DM-Internal-Test instance under Data_management_test Database (I have all the credentials: Hostname,Login,Password... for both instances).

Is there any way to use the Query Result of Instance A in Instance B and How please. Can you point me on such Tutorial or example please ?

Please see attached Screenshot.

Many Thanks Aymen

1 attachment(s):
  • HSQL_Forum
ansgar's profile image ansgar posted 4 years ago Permalink

Yes, HeidiSQL can export structure and/or data from one server to another one. I tried to explain this feature in the online help document.

Aymen_benk's profile image Aymen_benk posted 4 years ago Permalink

Merci Ansgar, I will take a look and come back to you with a result. :) Have a good start in the Week ^^

Please login to leave a reply, or register at first.