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.
You need to define real time. If it is 1 minute, yes. There are problems when you don't have a fixed IP on the subscriber. If you use a pull it should be fine. If you have a wireless router between the two you may have problems with NAT.
I normally use and recommend a VPN between the two for security.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.