Re: SQLServer2005/SQLC 3.5 Merge Replication

Yes, that is the only way, the AddSubscription call will add extra fields to
the subscribed tables, used for change tracking, and also add some system
tables to the sdf file.

--
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:Oe$mqW2tIHA.2068@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... Paul T. ... 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. ... How to: Create a Subscription (Programmatically) ... Create a SQL Server Compact Subscription (SQL Server Management ... would work with SQL Server 2005 and SQL Compact 3.5? ...
    (microsoft.public.sqlserver.ce)
  • SQLServer2005/SQLC 3.5 Merge Replication
    ... Can anyone point me to a smart device sample for merge replication that ... would work with SQL Server 2005 and SQL Compact 3.5? ... a suitably-prepared server database, publication, etc., but don't see how to ...
    (microsoft.public.sqlserver.ce)
  • Re: Replication for non-trusted domains through VPN can only allow push subscription.
    ... the repldata share on the publisher because the SQL Server Agent account on ... pass-through accounts to prevent the Windows Domain Account problem. ... What are the steps to setup and verify the pull subscription that I must ... > There are two modes - windows authentication and SQL Server Standard ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication for non-trusted domains through VPN can only allow push subscription.
    ... the repldata share on the publisher because the SQL Server Agent account on ... pass-through accounts to prevent the Windows Domain Account problem. ... What are the steps to setup and verify the pull subscription that I must ... > There are two modes - windows authentication and SQL Server Standard ...
    (microsoft.public.sqlserver.connect)
Quantcast