MS SQLCE - Transactions in SQL Ce 2.0

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Transactions in SQL Ce 2.0

Luis Soler

2005-08-28, 8:23 pm

Hi:

Which is the problem of transactions in SQL Server Ce 2.0 ?
Why says Microsoft that SQL Server Mobile really works with transactions ?

Regards

Ginny Caughey [MVP]

2005-08-28, 8:23 pm

Luis,

As I understand it, the new engine in SQL Mobile ensures that transactions
really are ACID. With SQL CE 2.0 it is possible to get partial transactions
written to the database, and corruption is also more likely. SQL Mobile also
performs faster than SQL CE 2.0.

Ginny Caughey
..NET Compact Framework MVP

"Luis Soler" <none@none> wrote in message
news:euNkQNArFHA.248@TK2MSFTNGP14.phx.gbl...
> Hi:
>
> Which is the problem of transactions in SQL Server Ce 2.0 ?
> Why says Microsoft that SQL Server Mobile really works with transactions ?
>
> Regards
>

Sponsored Links