compare and synchronize database

amroamro Posts: 2
edited November 20, 2015 6:56AM in SQL Data Compare 11
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
· Share on Twitter

Comments

  • Mike UMike U Posts: 316 Gold 1
    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.
    Development Lead
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.