Re: SQLServer2005/SQLC 3.5 Merge Replication

Yes. Is that the only way to create a subscription? I guess that's the
crux of my question...

Thanks for the pointers!
Paul T.

"ErikEJ" <ejlskov@xxxxxxxxxxx> wrote in message
news:OGY6mcxtIHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
Have you looked at this topic in Books Online:
How to: Create a Subscription (Programmatically)

and this:
How to: Create a SQL Server Compact Subscription (SQL Server Management
Studio)
(this will also generate code for you).

also the book by Rob Tiffany has some code samples:
http://www.amazon.co.uk/Windows-Mobile-Synchronization-Server-Compact/dp/0979891205/ref=sr_1_7?ie=UTF8&s=books&qid=1210916299&sr=8-7
(and lots of good advice)
--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

"Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT
com> wrote in message news:uQiPhTttIHA.3804@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

Can anyone point me to a smart device sample for merge replication that
would work with SQL Server 2005 and SQL Compact 3.5? I have what I think
is a suitably-prepared server database, publication, etc., but don't see
how to create a subscription with the tools, and can't figure out how to
do it in code, either.

There are obviously suitable classes in the SQL Compact 3.5 components,
but the right values for parameters are not documented worth anything and
my instincts have, so far, been wrong.

Thanks,
Paul T.






.

Relevant Pages

  • Re: SQLServer2005/SQLC 3.5 Merge Replication
    ... Check out my SQL Compact blog at ... Create a SQL Server Compact Subscription (SQL Server Management ...
    (microsoft.public.sqlserver.ce)
  • Re: SQLServer2005/SQLC 3.5 Merge Replication
    ... Paul T. ... Check out my SQL Compact blog at ... Create a SQL Server Compact Subscription (SQL Server Management ...
    (microsoft.public.sqlserver.ce)
  • Re: How update publisher db in case it fails ???
    ... while adding subscription put these params @sync_type = N'none' ... Paul Ibison wrote: ... >Your script below relates to bi-directional transactional replication. ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication error - schema
    ... This is the FIRST subscription I am trying to create. ... view that is referred to DOES exist on the Publication. ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication error - schema
    ... David ... > could drop the subscription, ass the view into the publication then readd ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
Quantcast