(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

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

"dw" <(E-Mail Removed)> wrote in message
news:599A7F95-8011-40A8-A8E1-(E-Mail Removed)...
> (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...

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

"Darren Shaffer" wrote:

> 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
>
> "dw" <(E-Mail Removed)> wrote in message
> news:599A7F95-8011-40A8-A8E1-(E-Mail Removed)...
> > (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
> >
>
>
>

"dw" <(E-Mail Removed)> wrote in message
newsAC0DCB7-B455-4E31-94F3-(E-Mail Removed)...

>
> 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/

--
David McNamee
Mobility Architect
developerLabs, Inc
http://www.developerLabs.NET/

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

"dw" <(E-Mail Removed)> wrote in message
newsAC0DCB7-B455-4E31-94F3-(E-Mail Removed)...
> 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
>
> "Darren Shaffer" wrote:
>
>> 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
>>
>> "dw" <(E-Mail Removed)> wrote in message
>> news:599A7F95-8011-40A8-A8E1-(E-Mail Removed)...
>> > (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...

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


"Darren Shaffer" wrote:

> 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
>
> "dw" <(E-Mail Removed)> wrote in message
> newsAC0DCB7-B455-4E31-94F3-(E-Mail Removed)...
> > 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
> >
> > "Darren Shaffer" wrote:
> >
> >> 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
> >>
> >> "dw" <(E-Mail Removed)> wrote in message
> >> news:599A7F95-8011-40A8-A8E1-(E-Mail Removed)...
> >> > (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
> >> >
> >>
> >>
> >>
>
>
>

Thank you for the information and link.
- dw

"David McNamee" wrote:

> 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/
>
> --
> David McNamee
> Mobility Architect
> developerLabs, Inc
> http://www.developerLabs.NET/
>
>
>