Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / August 2007

Tip: Looking for answers? Try searching our database.

SQL Mobile Replication subsciption and Hard Reset

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Renaud PORTIER - 23 Aug 2007 16:23 GMT
Hello,
My application uses sql ce merge replication on Windows CE 5 devices.
Database is stored on an internal flah memory (Persistent Storage). My
problem is that when a device is hard reset, the next database
synchronization will create a new subscription. Actually, merge agent
doesn't seem to be able to recognize the subscriber after it has been hard
reset, so it is considered as a new subsciber.
However, my replication doesn't allow multiple subcription per partition.

Is there a way to preserve subscription after device hard reset ?
ErikEJ - 23 Aug 2007 18:32 GMT
What is your Replication.HostName set to -
does it change after a hard reset???

Signature

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

> Hello,
> My application uses sql ce merge replication on Windows CE 5 devices.
[quoted text clipped - 6 lines]
>
> Is there a way to preserve subscription after device hard reset ?
Renaud PORTIER - 24 Aug 2007 09:26 GMT
Hostname is set to the device's serial number, so it doesn't change after
hard reset.
I think replication server considers the database as a new subscriber after
the device has been hard reset. Replication monitor shows a new subcription
(HostName + a unique id)  when I synchronize the database. The problem is
that my replication doesn't allow multiple subsciption per partition so this
synchro fails.

See MSDN :
"You can create the initial subscription on one smart device and then deploy
the application by copying the application and the initial subscription to
as many devices as you want. When the application first synchronizes, SQL
Server Compact Edition automatically recognizes it as a new Subscriber, due
to the new device and/or physical folder location change, and creates a new
subscription. By copying the initial subscription to a device, you avoid
downloading the initial subscription to the device over the network."
(http://msdn2.microsoft.com/en-us/library/ms172912.aspx)

My understanding is that SQL Server considers the device as a new one after
hard reset.

One more thing : I noticed that deleting the concerned partition on server
side (replication properties>partitions) seems to solve the problem, next
database sync are successful. However this is not a reliable solution as
devices are regularly hard reset due to battery fault.

Thanks for help !

> What is your Replication.HostName set to -
> does it change after a hard reset???
[quoted text clipped - 9 lines]
>>
>> Is there a way to preserve subscription after device hard reset ?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.