How to export MySQL data from a local server to UAT server using UiPath?

Help Activities
,
1

hello master,
i want to export data from local server to UAT sarver by UI path
plz guide me for the code
thank you

2

@Shubham_Bidwai

Can you please be a little eaborate on what the ask is?

Cheers

3

we have data okay that data add to local server and export to the UAT @Anil_G

4

For database activities in case you need to run some queries the below documentation will help:

But for export, better to look for MySQL documentation and tutorials externally, for as I know we don’t have a such feature.

Some examples:

https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html

5

@Anil_G i have two server local and UAT and want to copy data from UAT to local

6

@Shubham_Bidwai

Steps:

  1. Connect to local DB and copy data to datatable
  2. conect to UAT DB and write to DB.

Hope this help?

7

@Onyekachi_John can you elaborate

8
  1. create a sql connection to the local DB, then select all record you want to copy and write to a datatable.
  2. create a sql connection to the UAT environment and then Insert into the table.

if you need code snippet let me know.

Regards.

9

@Onyekachi_John please send code snippet

10

@Onyekachi_John we have sqlyog can not connected to ui path

11

Check the tread for how to connect