SQLCE2 compact database failing?

  • Thread starter Thread starter Strider
  • Start date Start date
S

Strider

Hello.

Has any of you heard of any issues on the compact and
repair database feature of the SqlCE provider?

It seems that - occasionally - the procedure fails
leaving an empty database without throwing an exception.

I am guessing that this it has something to do with the
memory (ram or flash) running out during the compact and
repair operation.

Any help would be greatly apprecieated!
 
I haven't experienced this problem my self but I am interested in knowing
about these problems..

In the examples I got (and use), I first create a backup of the original DB
before compacting, which ofc is a must. Can you reproduce the problem?

/ Peter
 
I do crete a backup, but the problem is that I am not getting an exception
thrown, the code assumes that everything was OK an I end up copying the
empty database over the original!

Still working on it. I will let you know if I come to any conclusions.
 
In our apps, after compacting the database and before copying it back we try
opening it and querying a few tables, that may not catch every possibility
but should handle most, then before copying the compacted one back we make a
backup of the original and leave it on the device, just in case!

Chris
 
Back
Top