Linking Remote Sql Server with Web server
I have got a project every thing is done except one .
i need to link to 3 sql servers running in 3 different areas,with a webserver,so that i can get all the data recieved on the webserver to yet another sql server at the Head office of the company.
An idea struck me to do this by simple queries but thats gona make it a slow process. I need to make it work faster,and also an automated one.I've heard that it can be done by MSDTC but i'm not much aware about this as i'm new to sql servers.
Any one got any idea to help me plz help me out!!!!!