Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crash safe db alternatives
Message
From
11/03/2010 10:25:23
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01453853
Message ID:
01453926
Views:
74
I like Sybase Sql Anywhere for this type of installation. Small footprint, easy to manage and very reliable. Works with ODBC, ADO, .NET. Can be configured to run as a service or start when your app starts and the shut down when your app disconnects.

>A lot of commentary here about migrating from VFP to .NET, Python etc. I accept all the arguments (mainly anyway).
>
>Don't hear so much about which db to migrate to that fits the "crash safe" criteria I have for using VFP tables:
>
> * very difficult to harm the tables in power failures, random reboots, voltage spikes etc
> * easy to strip out and rebuild table headers (and an app can sense and do this automatically)
> * yet high performance ...
>
>My app is typically run on a laptop (or dodgy hardware) in a remote location. I have one on a mine site that I haven't been able to visit since 2001!
>How robust is, say, MS SQL Server Compact Edition by comparison? Can you cut the power without corruption problems? Any other suggestions?
Previous
Reply
Map
View

Click here to load this message in the networking platform