Rainer
There's good news and bad news:
Good News:
SQL Server 2005 Express is free and let's you migrate toward SS2005.
SS2005 is also wonderfully compliant with SQL (which makes life
wonderfully easy once you get accustomed to it ;-)
I think there is also a relatively painless way to port your data
and data structures to SS2005
Once you convert your data access components, you can use the
same DataSource components and that means your data aware components
should work fine.
Bad News:
I suspect that you have been using mostly TTable components with
the BDE and you will need to change them to TADOQuery components.
You will also need to learn all the ins and outs of the
TADOConnection component.
IMHO, the good outweighs the bad
If you need more specific help, give me a holler . . . I'm always
happy to encourage the shift from BDE to SQL oriented databases. ;-)
At 01:58 AM 5/31/2007, you wrote:
>I have an application using BDE and Paradox tables that has overwhelmed
>the capabilities of BDE and/or Paradox -- too many records -- in Delphi
>7. Translation: a file gets corrupted after adding a few 100,000
>records. Every time.
>
>I really have no desire to totally rewrite all the database access
>routines (there are dozens and dozens). What is the least painful
>alternative database type to use? I am familiar with SQL from web site
>applications, but not in Delphi.
>
>All the file structures are static -- no adding or removing fields or
>indexes during execution. The programs are written for a single user --
>no locking worries. In BDE terms, I tend to use IndexName, Active,
>FindKey, FindNearest, Next, Prev, First, Last, Eoi, Edit, Insert,
>Append, Post, Delete, the "magic" type-converting field variables;
>DBGrid, DBNavigate, OnPost, and not much else.
>
>Suggestions will be much appreciated -- especially those that confine
>most code revisions to the Data Module or other central location.
>
>Thanks,
>Rainer
>
>
>
>_______________________________________________
>Delphi-DB mailing list
>Delphi-DB@elists.org
>http://www.elists.org/mailman/listinfo/delphi-db
Ralph D. Wilson II
Systems Analyst
Home: (210) 497-2643
Cell: (210) 387-7744
Fax: (210) 497-5726
[EMAIL PROTECTED]
[EMAIL PROTECTED]
_______________________________________________
Delphi-DB mailing list
Delphi-DB@elists.org
http://www.elists.org/mailman/listinfo/delphi-db
