i went through the documentation but i was not clear on following, here is the scenario :-
a Central server is having SQL Server 2000
3 Remote Locations :- Each having 4-5 no of computers, connected on a Lan, and on one of the machines MSDE 2000 will be running.
My Questions are :-
1. Can remote locations, update data locally and send changes (say in every one hour) to central server. If yes, then how ?
2. Same way they can receive updates from Central Server on whatever was updated on Centra Server or on the 3 remote locations. If yes, then How ?
any help will be highly appreciable.
Merge replication should be able to do this for you.|||Thanks for your answer.
Kindly note that if in this same scenario, can we do the same thing, if following combinations are used :-
1. SQL Express 2005 on Remote locations & on Central Server SQL Server 2005 is used ?
2. If Sql Express 2005 on Remote Locations & Central Database SQL Server 2000 is used ?
3. If MSDE 2000 on Remote Locations & Central Database SQL Server 2005 is used ?
|||#2 is not supported, this is documented in Books Online. #3 is supported, but you'll get better performance, scalability and functionality if #1 is used.
|||Thanks for reply... sorry for asking again n again...
For # 2 Option, if only features of SQL Server 2000 are used, still it is not possible ?
For #1 option, even i will prefer to use that, my only concern was in documentation they are mentioning that SQL Express server can only act as subscriber, so can it receive updates as well as send local updates, pls cfm ?
|||YOu can access SQL 2005 Books Online at http://msdn2.microsoft.com/en-us/library/ms203721.aspx. You can learn more about replication at http://msdn2.microsoft.com/en-us/library/ms151198.aspx.
A merge subscriber can upload and download changes.
