We're considering starting a move from dbISAM/4 to ElevateDB (EDB) this
summer.  Current component set version is 4.22b6, and I think the server
version is 4.21.  Applications are in Delphi (BDS2006).
I don't expect to see problems creating the database in EDB.  What do I
have to do to convert the programs?  Is it just a case of textual
search+replace in the *.pas and *.dfm files?  Is there a tool which does
"everything" necessary for the migration?
Any interesting things about properties that are no longer present in
the new components, or new important properties that I will have to fill
in?  Things that work totally different?  Peculiarities to look out for?
 Features that I will miss?

This seems to be the relevant product: EDB-VCL-CS.
(Client/server, unlimited clients)

--
Aage J.

Aage


Have a look at the migration guide in Tim's on-line manual. That's a good start point. Also have a look through the ng's for my posts and you'll see a lot of mention about things that are different.

Here's a few differences to get you thinking

EmptyString <> NULL in ElevateDB - hopefully changing in V2
Simple scripts no longer exist. There are wizzy new scripts and you can, depending on the content of the scripts, use a TEDBScript component
SELECT INTO has been replaced by CREATE TABLE AS which does not delete the target table
You can now have several memory databases but the inbuilt one is no longer there. There are minor consequences when the target for create table as is a memory table
IF EXISTS is no longer supported

Its a great new product, well worth making the change, but don't expect it to be as easy as going from BDE to DBISAM


Roy Lambert [Team Elevate]

Roy Lambert wrote:
> Aage
>
>
> Have a look at the migration guide in Tim's on-line manual. That's a good start point. Also have a look through the ng's for my posts and you'll see a lot of mention about things that are different.

Where is the on-line manual?
My computer just started av AV-scan, so browsing around in the
ElevateSoft web pages is very slow just now.


>
> Here's a few differences to get you thinking
>
> EmptyString <> NULL in ElevateDB - hopefully changing in V2
Hm.  I don't think this will be a problem, but an "empty string" surely
isn't Null. Or?

> Simple scripts no longer exist. There are wizzy new scripts and you can, depending on the content of the scripts, use a TEDBScript component
Not a problem, I think.

> SELECT INTO has been replaced by CREATE TABLE AS which does not delete the target table
> You can now have several memory databases but the inbuilt one is no longer there. There are minor consequences when the target for create table as is a memory table
> IF EXISTS is no longer supported
Some rewriting ahead, I see.

>
> Its a great new product, well worth making the change, but don't expect it to be as easy as going from BDE to DBISAM
I've certainly used the BDE, but didn't convert applications from BDE to
dbISAM.
>


--
Aage J.

Aage,

<< Where is the on-line manual? >>

It's included with all of the products in PDF, WinHelp, and MS Help 2
format, or here on the site:

http://www.elevatesoft.com/manual?action=mancat&id=edb1&product=d&version=7&category=2

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> Aage,
>
> << Where is the on-line manual? >>
>
> It's included with all of the products in PDF, WinHelp, and MS Help 2
> format, or here on the site:
>
> http://www.elevatesoft.com/manual?action=mancat&id=edb1&product=d&version=7&category=2
>


Thanks, this seems to cover the lot.
I seem to remember that when (about ten years ago!) I converted from BDE
to IBO (Interbase Objects), there was a utility - GReplace - which did
(almost?) all the conversion of component names in *.pas and *.dfm in
one go.
<searching ...>
Yep, GReplace.zip is still there at http://www.obsof.com/public
Maybe you could create something to ease the migration for all of us...

--
Aage J.

Aage,

<< Yep, GReplace.zip is still there at http://www.obsof.com/public Maybe you
could create something to ease the migration for all of us... >>

There are already component search-and-replace experts out there, as you
point out.  What would be the point of us spending time developing something
that is already freely available ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> Aage,
>
> << Yep, GReplace.zip is still there at http://www.obsof.com/public Maybe you
> could create something to ease the migration for all of us... >>
>
> There are already component search-and-replace experts out there, as you
> point out.  What would be the point of us spending time developing something
> that is already freely available ?
>

Just collecting all the name changes.  Instead of some/all users hunting
through the docs to find old/new component names.  Maybe it isn't
possible to save the change specifications - I'll check when I start
migrating.


--
Aage J.

Aage


If Tim did it he'd almost certainly get it wrong you have to make a decision wether to replace TDBISAMQuery with TEDBQuery or TEDBScript.

But there's very few things search and replace can help you with - a comprehensive list:

TDBISAMEngine -> TEDBEngine
TDBISAMSession -> TEDBSession
TDBISAMDatabase -> TEDBDatabase
TDBISAMTable -> TEDBTable
TDBISAMQuery -> TEDBQuery or TEDBScript

That's it anything else is down to programming.

Years ago when I switched from BDE to DBISAM I wrote my own utility to do global string changes. You're welcome to a copy if you want one.

Roy Lambert [Team Elevate]

Roy Lambert wrote:
> But there's very few things search and replace can help you with - a comprehensive list:
> TDBISAMEngine -> TEDBEngine
> TDBISAMSession -> TEDBSession
> TDBISAMDatabase -> TEDBDatabase
> TDBISAMTable -> TEDBTable
> TDBISAMQuery -> TEDBQuery or TEDBScript

Thank you for a comprehensive list that is short!

--
Aage J.