SQL2008 Replication / synchronization with SQL Express Editon

[Karsten]

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

[Paul Ibison]

PLease take a look here: http://www.replicationanswers.com/WSM.asp
HTH,
Paul Ibison

[Karsten]

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]

Please can you post up the script of the subscription and I'll takea look.
Cheers,
Paul Ibison

[Karsten]

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]

It's missing @enabled_for_syncmgr=true in sp_addmergesubscription -
hopefully this is it.
paul

"Karsten" <Kar...@discussions.microsoft.com> wrote in message
news:0662C07B-35E2-4E33...@microsoft.com...

[Del]

Karsten,
Can you tell me where Synchronization Manager is located in Windows Server
2008? I've looked in Start -> All Programs -> Accessories, but it's not
there. Has it been moved or renamed; do I need to add a Role? Thank you.