I need to migrate a lot of paradox data in a very fast server. I don't want (if is possible) to install the ancient BDE on this machine.

Can edbmigratebde.dll migrate with no BDE installed?

Thanks.

Tiago


Looking at the migrator source it uses DB,DBTable and TDatabase so I suspect not. Easiest way to find out is to try it.

There is software around (http://www.sportamok.com/development/delphi/3-delphi/8-paradox-dbase-reader) that will allow you to access Paradox tables without the BDE so you could use one of those and modify the migrator if it does need the BDE or roll your own since apart from the structure all Tim's doing is generating a wadge if INSERT statements and running them.

Roy Lambert [Team Elevate]

Roy,

Thanks for your response. The fact (after some investigation) is

a)Migrator's source code seems not need BDE, but YES, BDE is needed: in a clean machine migrator ask for it :-<
b)Migrating from BDE in my development machie is slooooooow (task manager is quiet, few Kbytes are added to destination tables every minute,
yet migrator is alive, but very slow). After two hours with a few Mbytes migrated, I stoped it.

My workaround is so esasy as:
1. Use old fried dbisam bdetrans to migrate from paradox to dbisam4 (wich not needs nothing installed on my server). It's very fast.
2. Migrate from dbisam4 to EDB, wich is pretty fast.

So my data will trip around the world to finally arrive to EDB

Tiago,

<< a)Migrator's source code seems not need BDE, but YES, BDE is needed: in a
clean machine migrator ask for it :-<
b)Migrating from BDE in my development machie is slooooooow (task manager
is quiet, few Kbytes are added to destination tables every minute,
yet migrator is alive, but very slow). After two hours with a few Mbytes
migrated, I stoped it.

My workaround is so esasy as:
1. Use old fried dbisam bdetrans to migrate from paradox to dbisam4 (wich
not needs nothing installed on my server). It's very fast. >>

That's weird.  You're using the exact same installation of the BDE in both
cases ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
<That's weird.  You're using the exact same installation of the BDE in both
cases ?>

Sorry, I forgot to mention what I used bdetrans *in my development machine*, it has BDE installed. This is fast. Then, the rest of migration
(porting from dbisam4 to EDB and a bunch of SQL to convert data) is done in end user server.

The extrange thing is with same amount of data bdetrans is pretty fast (file server mode), while bde migrator for EDB is very, very slow
(client/server -same machine- mode).  Before posting this message, I discovered that edb server is 2.2.0.9 while bde migrator dll is 2.2.0.3 (I
forgot to copy last version in config directory).

Tiago,

<< Sorry, I forgot to mention what I used bdetrans *in my development
machine*, it has BDE installed. This is fast. Then, the rest of migration
(porting from dbisam4 to EDB and a bunch of SQL to convert data) is done in
end user server. >>

Okay, so let me get this straight:

1) Is it the BDE migrator, the DBISAM 4, migrator or both, that are slow ?

2) Is the slow migrator only slow on a particular machine, or on any machine
?

In general, the migrators in EDB may be slightly slower than the BDETran
utility due to the fact that EDB requires a flush of the catalog to disk
after every new CREATE or ALTER statement.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
<1) Is it the BDE migrator, the DBISAM 4, migrator or both, that are slow ?

2) Is the slow migrator only slow on a particular machine, or on any machine
?>

Here are my chronometer in hand results.

Considerations:
0. Another machine (yesterday I was at home)
1. File server based connection (yesterday was client/server, same machine, port 127.0.0.1)
2. 2.2.0.10 version in both EDBmgr and dll's (yesterday was 2.2.0.9 server and 2.2.0.2 bde migrator dll)

Results:

PDX. Had 56 files 31.336.448 bytes BDEtrans took 14 seconds to migrate to DBI4 and generated 52 files 46.053.232 bytes
Same source took 3:43 minutes to migrate to EDB and generated 65 files 62.516.888 bytes
DBI4: 52 files 46.053.232 bytes took 3:20 minutes to migrate to EDB and generated 65 files 62.683.760 bytes

Conclusions:
May be client/server, version misc or BDE configuration on that machine, but yesterday after 2 hours bde migration was still running (not
hanged) !!

Tiago


What are the extra files?

Roy Lambert

Roy,

<What are the extra files?>

Ooops, my test were contaminated with these stupid .old files! They were there from another migration.

Where can I put my signature to get a NOBACKUP ?

Tiago

>Where can I put my signature to get a NOBACKUP ?

Tim has promised it sometime.

Roy Lambert