Sunday, October 4, 2009

How to update two sql server installed in different computers in. net application through internet?

I am developing .net application and want to update two sql server installed in different computers through internet. Is it possible than how to do please reply ASAP



How to update two sql server installed in different computers in. net application through internet?norton ghost



Can you just use replication? Another option is to pass the same values on the code to save thedata to the second server in the connectionstring.



In essense you have two connections open pointing to different servers and just save whatever you need to save base on the values you picked up from the user.



I don't know if your question is more complex that what it seems. I only can imagine that you want to save data to two sql servers on different sites (domains). If the sites are not connected or reachable that might be the reason you are asking.



To connect sites I use a vpn like openvpn then I have access to all resources on both LANs.



Cheers!

No comments:

Post a Comment