Remove From My Forums

Merge Replication - Pull From Client

Question
0

Sign in to vote

Hi All,

I tried to configure subscription on a client to pull from the server. I was able to get it configured, but I can't seem to figure out how to get it to sync. I tried to use the sync manager in the control panel, but ti didn't appear that anything showed up? I am using SQL Server Express 2008 R2 as the client, which means that I can't configure the SQL Agent (I assume). What is the best method to actually configure the client subscription? I can configure it on the server, but it appears that there could be some issues with the Publisher (server) actually connecting and sending data down to the clients.

I looked briefly into the merge replication over web, but was concered with the same thing I ran into today. How do you set up the client sync?

I found on the web that others were having the same issue with the sync manager.

Any suggestions / info would be appreciated.

Thanks,

B

Wednesday, April 6, 2011 3:44 AM

Answers

0

Sign in to vote
Use Windows Task Scheduler for this.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed as answer by Replfun Wednesday, April 13, 2011 2:07 AM
- Marked as answer by Alex Feng (SQL) Wednesday, April 13, 2011 11:40 AM
Thursday, April 7, 2011 1:31 PM

Answerer
0

Sign in to vote
Update:

I can run Merge Agent via Task Scheduler to sync pull merge subscription on SQL Server 2008 R2 Express, check my another thread: http://social.technet.microsoft.com/Forums/en-US/sqlreplication/thread/0ef1d3f7-5667-4227-bb93-69de934ab361.
Please mark replies as helpful or answers if they are helful, doing so can help others encountering the similar issue.
- Marked as answer by Alex Feng (SQL) Wednesday, April 13, 2011 11:40 AM
Wednesday, April 13, 2011 2:07 AM

All replies

0

Sign in to vote

Hi,

Did you try the steps in the following Books Online article: How to: Synchronize a Subscription Using Windows Synchronization Manager?
Best Regards,
Chunsong Feng

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Thursday, April 7, 2011 9:17 AM
0

Sign in to vote
Use Windows Task Scheduler for this.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed as answer by Replfun Wednesday, April 13, 2011 2:07 AM
- Marked as answer by Alex Feng (SQL) Wednesday, April 13, 2011 11:40 AM
Thursday, April 7, 2011 1:31 PM

Answerer
0

Sign in to vote

Hi Hilary,

I encounter the same issue as Ben mentioned. Do you mean that we cannot use Windows Sync Manager (Sync Center in Windows 7 and Windows Server 2008 R2)? Instead, we need to use Task Manager. If so, do you have any docs pointing out how to configure that?

Thanks in advance.
Please mark a reply as helpful if it was helpful to resolve your issue; and mark a reply as answer if it resloved your issue.

Friday, April 8, 2011 4:30 AM
0

Sign in to vote

Officially it is supported. How, I simply don't know. I use task manager.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Sunday, April 10, 2011 7:52 PM

Answerer
0

Sign in to vote

Many thanks to Hilary. I cannot find much information about how to configure that in Task Manager, can you provide additional steps?

Thanks again.

Please mark replies as helpful or answers if they are helful, doing so can help others encountering the similar issue.

Monday, April 11, 2011 1:50 AM
0

Sign in to vote
Update:

I can run Merge Agent via Task Scheduler to sync pull merge subscription on SQL Server 2008 R2 Express, check my another thread: http://social.technet.microsoft.com/Forums/en-US/sqlreplication/thread/0ef1d3f7-5667-4227-bb93-69de934ab361.
Please mark replies as helpful or answers if they are helful, doing so can help others encountering the similar issue.
- Marked as answer by Alex Feng (SQL) Wednesday, April 13, 2011 11:40 AM
Wednesday, April 13, 2011 2:07 AM

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Answered by:

Merge Replication - Pull From Client

Question

Answers

All replies