February 7, 2005 at 11:41 pm
Hi.I want to replicate SQL 2005 - SQL 2005 Express. MS SQL 2005 (DevEdition beta 2) is configured as Publisher/Distributor.
I want to configure SQL 2005 Express (beta 2) as Subscriber for merge replication (pull-subscription). For this purposes used T-SQL command
(at Subscriber) sp_addmergepullsubscription (after it runs in subscriber database appears some system tables for "replication managment")
Next step is to run (at Subscriber) sp_addmergepullsubscription_agent procedure. I use it in this way:
use [DB_FOR_REPLICATION]
EXEC sp_addmergepullsubscription_agent
@name = ..., @publisher = ..., @publisher_db = ..., @publication = ...,
@publisher_security_mode=0, @publisher_login = ..., @publisher_password = ...,
@distributor_security_mode=0, @distributor = ..., @distributor_login = ..., @distributor_password = ...,
@job_login = ..., @job_password = ...,
@use_interactive_resolver='false', @enabled_for_syncmgr='true',
@frequency_type=4, @frequency_interval=8, @frequency_subday=4, @frequency_subday_interval=1, @active_start_date= 20050101
GO
As I understand this mean that: SQL server authentication used for both Publisher/Distributor(login/pswrd i supplied), replication
is sheduled to run every minute since 2005 jan 01 and _subscription can be synchronized through Windows Synchronization Manager_.
Questions:
1. Does Windows Synchronization Manager keep password i provided in SP above? (every time i'm trying to run it asks me to enter 'em again).
2. Where i can find schedule mentioned in SP (every minute since...)? Its not displayed in SyncManager.
3. What happens when @enabled_for_syncmgr='false'? I cant syncronize DBs at all. No agent tables in Subscription database and no schedule in MSBD.
Thnx for answers
Best Regards Maxim Morzhov
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply