Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 11 total |
Is needed BDE installed on server machine to migrate to EDB? |
Wed, Mar 11 2009 4:52 AM | Permanent Link |
Tiago Ameller | 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. |
Wed, Mar 11 2009 7:16 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Wed, Mar 11 2009 7:51 AM | Permanent Link |
Tiago Ameller | 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 |
Wed, Mar 11 2009 5:09 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Mar 11 2009 6:02 PM | Permanent Link |
Tiago Ameller | 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). |
Wed, Mar 11 2009 6:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Mar 12 2009 5:30 AM | Permanent Link |
Tiago Ameller | 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) !! |
Thu, Mar 12 2009 6:30 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tiago
What are the extra files? Roy Lambert |
Thu, Mar 12 2009 6:57 AM | Permanent Link |
Tiago Ameller | 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 ? |
Thu, Mar 12 2009 7:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tiago
>Where can I put my signature to get a NOBACKUP ? Tim has promised it sometime. Roy Lambert |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |