how to fetch data from another server?

[hammadtariq]

hello,
I have a mysql database on the server and a SQL server database on my local machine. What I want to make a script that fetches the data from that mysql database on the server and stores it into the SQL server database on the local machine. Any idea about how can I achieve that?

[Moharo]

Hey,

First of all, you need to have the permission to access the other server, then you need to write a code that will fetch the data. that's it 🙂

[hammadtariq]

I have access of other server..and all I am asking is how to write the code, did i have to write lib curl or some thing else?