How to compare two Mysql tables in different databases and update

Question

I have a c# asp.net 2.0 project in which i'm using Mysql as backend. I'll have two databases one in the remote web server and on in a local server. Both theses databases are identical. The manual changes will be made to the local database. i need to compare these tables with that of the remote database tables and update any matching rows and to insert any new rows. which is the best way to do this ? Thank you for your time.

Mahesh Chand · Answer

Is this a one time compare deal or you will be doing this all the time and need some code to do so? If it is one time think I suggest go to www.redgate.com and download SQL Compare. You will find how much time this tool can save you. If its an ongoing thing you can get data from both databases in two DataSets and compare using DataSet methods. Here is one post on DataSet compare: http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=44162