I need to write a program that will synchronize two sql tables. Having no luck with php/phpMyAdmin, I've turned to VB.NET...but I'm still not having any luck.

I've found various examples on the internet but none of them compile. It has to compare each record, and only update the fields that have changed, instead of just overwriting the older one. One table will be local, the other is on a server.

It seems no one has written this type of program for free, all I can find are $200+ synchronizer programs.

I've already wasted about 2 days trying to find answers :mad:
Any help would be greatly appreciated.

~YC