Ronaldo Souza wrote:
Quote
Hi,
The appps we are working on are primarily data-acquisition/processing
systems and the DB stuff is NOT our top priority. Our DBs are basically
data storage: 90% are single-user and 10% with up to 5 simultaneous
users basically WRITING to the DB. Record collisions are very rare. We
use SQL for some reports but nothing really fancy. Our files are
basically a bunch of blobs totaling usually 500K.
We have been using Delphi/BDE/Paradox since 98, with the usual problems,
no big deal, but now things are changing: my experience with the XP-SP2
problem is that the solutions proposed here and elsewere work about half
the time and I expect it to get worse with time. I just spent an
afternoon trying (without success) to fix a system that was working fine
yesterday and, after an automatic windows update, stopped working today.
The only solution was to restore Windows to the point just before the
update.
With regret, we decided it's time to migrate to another database. The
question is: which ? Big factors on this decision will be:
1) Future support/enhancement.
2) How easy the migration process will be? Is the new DB similar to
BDE/Paradox?
3) Is there a tool to "translate" at least some of the code (Delphi)?
4) Source code available ? (Delphi)
5) Available on Linux?
Factors 1 and 2 are real deal breakers!
Thanks in advance for any thoughts, experiences, etc.
Ronaldo
I am currently in the process of migrating a BDE application from
TurboDB -
www.turbodb.de/en/products.html. Addressing your issues.
1. They have released 3 or 4 minor version enhancements since I
purchased the TurboDB a year ago. I have not need much support recently
, but the email support was excellent when I first started to use the
product.
2. TurboDB is nearly identical to the BDE TTable component. I do
recall that they did not implement the SetRange function. My
application was written with native IDAPI calls, and the migration
process was not without pain. I had to write a custom program to
translate the BDE database to TurboDB.
3. See number 2 above. Based on the timeframe your application was
developed, I doubt you use VCL components; therefore, you code migration
will not be easy.
4. Source code? I did not purchase it, but I thought there was a more
expensive version that included it. I could not verify this with a
cursory glance at there website.
5. The website shows CLX components; therefore, Linux is support to
some degree.
Drawbacks
1. The developers are German speaking and the English documentation
falls short sometimes. A case in point: they used the German word
eigenvalue for property in the English documentation.
2. I do not believe TurboDB is as fast as BDE. I have not written any
applications to test this opinion. This is based entirely on the speed
at which selected records appear on the TDBGrid.
I am available via email if you have any questions that you do not feel
would be of general interest in the newsgroup.
HTH,
Danzer