compare and synchronize database

amro

hi
i have two database in different location .
each data have same schema
i want make synchronized auto as service by vb.net 2008
please send to me any example to do that .
i want apply it in all branch in middle east
(note citrix in some branch in very slow)

thanks

Mike U

I'd suggest you just use the data compare command line to do that - from vb.net you can use Process.Start to call the command line appropriately. The command line is documented here.

The correct solution if you want the data to be continuously synchronised is probably to use replication.