Cancel SQL CE Replication gracefully?

[Guest]

(i already posted this message a few days ago on the sql ce newsgroup and no
one has been able to help me...)

Hello...

We are running a .Net CF app with SQL CE 2.0.

In the cases where there is a long running replication process (we have some
mobile devices that are replicating via cell modem...a requirement), does
anyone know of a way to cancel gracefully out of a replication process?

I was thinking of changing our current replication function to operate on a
background thread for starters...but then....is there a "cancel" or "abort"
call that I can use to gracefully end replication? I don't want to corrup
the local SQL CE database or cause other app errors if possible.

thanks
- dw

 

[Darren Shaffer]

unfortunately, there is no way to stop a synchronize() command
once started with SQL CE. in SQLMobile, there are asynch
callbacks that allow you to monitor the progress of a replication
and cancel the replication if necessary. SQLMobile is available
with VS2005B2 and SQL Server 2005 April or June CTP.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

 

[Guest]

Darren...

Thanks so much for the prompt reply and information. I was afraid that this
was going to be the answer...but I needed to know so I can plan out our
project roadmap. Do you know if there has been enough community use of
SQLMobile to use it in a production environment? Is there any place that I
can go to find out current usage anecdotes, facts, metrics, etc?

thanks again
- dw

 

[David McNamee]

Do you know if there has been enough community use of
SQLMobile to use it in a production environment? Is there any place that
I
can go to find out current usage anecdotes, facts, metrics, etc?

I don't know of anything other than anecdotal evidence that SQL Server
Mobile is good enough to go. The best thing to do would be to test out your
application on it. If you wind up happy with it, check out the Beta 2 Go
Live License here:
http://lab.msdn.microsoft.com/vs2005/golive/

 

[Darren Shaffer]

DW -

I have already deployed a Field Service app and a Delivery App
with SQLMobile using GoLive Licensing. One uses Merge Replication
to SQL Server 2005 April CTP. I have not encountered any stability issues,
which is not to say the product is RTM, but to encourage you that it is good
enough for production use. I work closely with the MS SQLMobile and CF
teams and have reported a number of bugs which they have or are resolving.

After two dozen CF apps using SQL CE, I have learned to keep my usage
of these databases clean and simple on device. Where people have issues
with this
technology is when they begin to push the limits of it's capabilities - a
merge
publication with filters that span 6 tables, tables with 300k rows, queries
with 4 joins (that involve the table with 300k rows!), etc.

Use SQL CE and SQLMobile for what they do best - great
off-line relational data caches for Windows Mobile devices and some built
in data synch technolgy - and you'll be fine. You can't beat the price.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

 

[Guest]

Darren...

Thank you for the information on how you are using SQLMobile.

One question...does SQLMobile require SQL2005 or will SQLMobile work (using
Merge Replication) with SQL2000? I ask because I could see us moving to
SQLMobile sooner than SQL2005, and I'd like to take advantage of some of the
new SQLMobile features and functionality.

thanks again
- douglas

 

[Guest]

Thank you for the information and link.
- dw