SQL CE Synchronization

[Darrin]

Hi,
Does anyone have any resource suggestions for quickly getting up to
speed with synchronizing a SQL CE 2.0 table with a SQL Server 2005
table using USB/ActiveSync from a PocketPC 2002 device? Can this be
done with USB if the user logged into the workstation has access to
the SQL 2005 database? Thanks in advance!

 

[Guest]

One solution is Replication:
http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Also, see if this helps:
http://blogs.msdn.com/robtiffany/ar...1-getting-started-with-merge-replication.aspx

Also try searching the archives, this is a frequent question within this
group.

 

[msgroup]

You may use SocketPro at www.udaparts.com for synchronizing a SQL CE 2.0
table with a SQL Server 2005 programmatically.

See the site http://www.udaparts.com/groups/viewtopic.php?t=534

Cheers

 

[Pavel Bansky (MSFT)]

Download the following demo. It has very good documentation on SQL
Server 2005 and Compact SQL Server replications.
Nice one with lot's of screen-shots.

http://www.microsoft.com/downloads/...C5-4F9B-4C1A-BFF6-2A3C6B68D15B&displaylang=en