Replication RRS feed

  • Question

  • Hi there,

    We are developing a system where we have an e-commerce portal through which we can sell items that are at the shops of our vendors. The website is connected to a ms sql server standard edition and has a fixed ip address. At vendors end, we are providing them a small pos software which will have ms sql express or compact edition which will be connected to internet. Also, there will be no fixed ip address at vendor's end.

    My question is, in this scenario is it possible to have real time bi-directional synchronization. That is, if anything is sold on the vendor's side, it gets reflected on the central ms sql standard edition server (having fixed ip address) in real time and if anything is sold on the website it gets reflected on the vendor's panel (consisting ms sql express edition, dynamic ip address) in real time.

    I would be highly thankful if someone can suggest the proper architecture for achieving the same.

    Thanx in advance.

    Saturday, April 27, 2013 9:04 AM