Hello!
Question of such plan, to documentation to Microsoft SQL Server 2005 Express Edition it is written, that the given product supports only PUSH replication, however in his{its} structure there is an agent replmerg.exe which description says:
replication merge. Synchronization means, that the agent of merge transfers changes from the subscriber to the publisher, and then transfers changes from the publisher on the subscriber …
And so the question if this agent is present at this edition, whether that is possible to adjust manually his{its} call, or through Windows the agent, for realization PULL replication or it is impossible and for what reasons?
Thanks.
You can find replmerg.exe in Program Files\Microsoft SQL Server\90\COM even on an Express instance.
The missing thing in Express is the SQL Server agent. Hence the merge agent cannot be started using SQL Server agent with a pull subscription. If you want to use the SQL Server agent in this setup then you will need to use push subscription. Or you can get by and use the executable or use Windows Synchronization manager or use RMO components to start the merge agent programatically.
|||And why I cannot use instead of SQL Server Agent, Scheduled Tasks Windows, For start replmerg.exe with parameters PULL of the subscriber, or my attempt will not be possible? Why?
|||I do not understand your question. You can use one of the following:
1. Windows sync manager (pull subscription)
2. Command line executable replmerg.exe
3. RMO objects.
|||You have told that:
1. Windows sync manager (pull subscription) It Is possible{probable}, yes?
Probably, on SQL Server Expression to realize PULL replication with help Windows sync manager with use of the utility replmerg.exe?
I simply did not use never Windows sync manager.
|||Windows sync manager is separate from using the replmerg.exe command line tool.
Windows Sync manager can be found in Start-->Programs-->Accessories-->SYnchronize.
For more info refer to:
http://msdn2.microsoft.com/en-us/library/ms165714.aspx
http://msdn2.microsoft.com/en-us/library/ms151863.aspx
|||
Ok, thanks!!! You have very much helped, all has turned out:-)
When I have adjusted pull replication SQL Server express and have set the schedule of performance with help Windows Sync manager, at each start it{he} asks login and password for communication{connection} with Publisher and Distributer? How to make that it{he} did not ask these given, and all did{made} automatically?
|||I am not sure if you can save the credentials.|||I have bad understood the answer, here is here detailed description of the question, I his(its) has described, read and help to solve a problem. Thank you!
http://www.replication2006.narod.ru/SQLEPW.mht
|||
Are you asking that what you could do with Windows sync manager, can it be done with Merge agent replmerg.exe?
If so, yes. You need the appropriate parameters set for the utility. Running replmerg.exe /? will show you all the available parameters and set them accordingly and run it. It should succeed.
|||OK thank you, problem is solved.
