Prev: Replication Solution
Next: Increasing Max Text Repl Size
From: Karsten on 19 Oct 2009 09:50
Hello!

We´d like to implement Replication between a SQL Server 2008 Server
and some Client PC.

Server: Windows Server 2008 standard + SQL Server 2008 standard SP1
Clients: Windows XP Professional + SQL Server 2008 Express SP1

A Merge-Publication was set up on the Server side.

On the Clients, we could successfully set up the according subscription.

Then, we went on like described in the Articles…

http://technet.microsoft.com/en-us/library/ms151819.aspx

and

http://technet.microsoft.com/en-us/library/ms151863.aspx

… to set up the synchronization with “Windows Synchronization Manager”
(as an alternate way to using SQL Server Agent Jobs).

After enabling the option „Use Windows Synchronization Manager“ the
subscription
shout be visible under “items to synchronize” in the Synchronization Manager.
But there are absolutely no items to synchronize.

The alternate way to solve this problem by using RMO-Programming
unfortunately is
no solution for us.

What do we have to do, to set up synchronization by using the
Synchronization Manager?

Thanks in advance for your efforts.

Karsten


From: Paul Ibison on 19 Oct 2009 16:11
PLease take a look here: http://www.replicationanswers.com/WSM.asp
HTH,
Paul Ibison

From: Karsten on 20 Oct 2009 05:13
Thank you for your reply, Paul.

It´s a very useful Article, but I´ve done exactly the described steps
and nothing appears in the WSM.

Do you have another idea?

Thank you very much!

Greetings

Karsten




"Paul Ibison" wrote:

> PLease take a look here: http://www.replicationanswers.com/WSM.asp
> HTH,
> Paul Ibison
>
From: Paul Ibison on 20 Oct 2009 13:26
Please can you post up the script of the subscription and I'll takea look.
Cheers,
Paul Ibison

From: Karsten on 21 Oct 2009 03:26
Hi Paul!

Here´s the script of the subscription...

-------------------------------------------------------------------------------------------
-- Mergepullabonnement wird hinzugefügt

/****** Anfang: Auf dem Abonnenten auszuführendes Skript ******/
use [TheApplication_Replikat]
exec sp_addmergepullsubscription
@publisher = N'PublisherDistributorServer',
@publication = N'TheApplication',
@publisher_db = N'TheApplication',
@subscriber_type = N'Local',
@subscription_priority = 0,
@description = N'',
@sync_type = N'Automatic'
GO


exec sp_addmergepullsubscription_agent
@publisher = N'PublisherDistributorServer',
@publisher_db = N'TheApplication',
@publication = N'TheApplication',
@distributor = N'PublisherDistributorServer',
@distributor_security_mode = 1,
@distributor_login = N'',
@distributor_password = N'',
@enabled_for_syncmgr = N'True',
@alt_snapshot_folder = N'',
@working_directory = N'',
@use_ftp = N'False',
@job_login = null,
@job_password = null,
@publisher_security_mode = 1,
@publisher_login = N'',
@publisher_password = N'',
@use_interactive_resolver = N'False',
@dynamic_snapshot_location = N'',
@use_web_sync = 0
GO
/****** Ende: Auf dem Abonnenten auszuführendes Skript ******/


/****** Anfang: Auf dem Verleger auszuführendes Skript ******/
/*use [TheApplication]
exec sp_addmergesubscription
@publication = N'TheApplication',
@subscriber = N'NOTEBOOK\TheApplicationLOKAL',
@subscriber_db = N'TheApplication_Replikat',
@subscription_type = N'pull',
@subscriber_type = N'local',
@subscription_priority = 0,
@sync_type = N'Automatic'
*/
/****** Ende: Auf dem Verleger auszuführendes Skript ******/

-----------------------------------------------------------------------------------------

Thanx in advance

Greetings

Karsten




"Paul Ibison" wrote:

> Please can you post up the script of the subscription and I'll takea look.
> Cheers,
> Paul Ibison
>
 |  Next  |  Last
Pages: 1 2
Prev: Replication Solution
Next: Increasing Max Text Repl Size