We have six locations and are looking to replicate data from these six locations to one site for billing purposes We are using SQL 205 with a . NET framework and using a Visual Basic GUI custom program for entering and getiing the data. What is the best way to set up the network so that all site can see all the data so everything can be billed properly? We are hoping to be able to have a Microsoft solution rather than a third partyu one.
