I added the option -exchangetype 2 to the agent and any changes i make at the
subscriber are being pushed back to the publisher...
I am terribly confused...
After more research i realised that i was changing the snap shot agent and
not the merge agent.
Secondly i also figured out when i subscribe via SQL Server Mobile, the
Merge Agent is not editable meaning on SQL2k when i right click on the Merge
Agent and ->Agent Properties it asks for a user name and password and tries
to connect to a database that has the name of my subscription.
So what i am wondering is, can i configure a merge agent that is
created/iniated by SQL Server Mobile?
|||Not really, you need to code your merge replication sync in vbscript, csharp
or vb.net. Use the ExchangeType Property setting for this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ming Yeung" <MingYeung@.discussions.microsoft.com> wrote in message
news:29250BBC-E9F1-4478-B5B3-45F31036FE30@.microsoft.com...
>I am terribly confused...
> After more research i realised that i was changing the snap shot agent and
> not the merge agent.
> Secondly i also figured out when i subscribe via SQL Server Mobile, the
> Merge Agent is not editable meaning on SQL2k when i right click on the
> Merge
> Agent and ->Agent Properties it asks for a user name and password and
> tries
> to connect to a database that has the name of my subscription.
> So what i am wondering is, can i configure a merge agent that is
> created/iniated by SQL Server Mobile?
|||Thanks for the response...
Do you have a link on how to do the above with C#?
Regards and Thanks In Advance
"Hilary Cotter" wrote:
> Not really, you need to code your merge replication sync in vbscript, csharp
> or vb.net. Use the ExchangeType Property setting for this.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Ming Yeung" <MingYeung@.discussions.microsoft.com> wrote in message
> news:29250BBC-E9F1-4478-B5B3-45F31036FE30@.microsoft.com...
>
>
|||try this:
http://support.microsoft.com/kb/319646
Note that you would need to specify a value for
SQLMERGXLib.ISQLMerge.DynamicSnapshotLocation.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ming Yeung" <MingYeung@.discussions.microsoft.com> wrote in message
news:FDEC4E9E-BA7D-481F-B95D-347987439BCD@.microsoft.com...[vbcol=seagreen]
> Thanks for the response...
> Do you have a link on how to do the above with C#?
> Regards and Thanks In Advance
> "Hilary Cotter" wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment