SQLServer2005/SQLC 3.5 Merge Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul G. Tobey [eMVP] - 15 May 2008 22:44 GMT

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.

Reply to this Message

ErikEJ - 16 May 2008 06:38 GMT

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/0979891
205/ref=sr_1_7?ie=UTF8&s=books&qid=1210916299&sr=8-7
(and lots of good advice)

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> Hi,
>
[quoted text clipped - 10 lines]
> Thanks,
> Paul T.

Reply to this Message

Paul G. Tobey [eMVP] - 16 May 2008 16:01 GMT

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.

> Have you looked at this topic in Books Online:
> How to: Create a Subscription (Programmatically)
[quoted text clipped - 21 lines]
>> Thanks,
>> Paul T.

Reply to this Message

ErikEJ - 17 May 2008 15:40 GMT

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.

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> Yes. Is that the only way to create a subscription? I guess that's the
> crux of my question...
[quoted text clipped - 27 lines]
>>> Thanks,
>>> Paul T.

Reply to this Message

Paul G. Tobey [eMVP] - 19 May 2008 16:05 GMT

Thanks, Erik. I have it working and have a much better idea of what's
possible.

Paul T.

> 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
[quoted text clipped - 31 lines]
>>>> Thanks,
>>>> Paul T.

Reply to this Message