Tim

Is there an easy (and fast) way of migrating tables in memo fields from DBISAM to ElevateDB.

The hard, slow way, I've figured out is to unpack into a DBISAM table, loop round doing inserts into an ElevateDB table and stuff the result back.

Roy Lambert

Roy,

<< Is there an easy (and fast) way of migrating tables in memo fields from
DBISAM to ElevateDB. >>

Not really, no.

<< The hard, slow way, I've figured out is to unpack into a DBISAM table,
loop round doing inserts into an ElevateDB table and stuff the result back.
>>

That's about the only way.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Ah well, grumble, grumble, mutter, mutter, moan, moan.

I just hope that you're doing it in the same way as DBISAM at the end and I won't have to worry about structure changing throughout the life of ElevateDB. If there's much chance of that I might as well start thinking about alternative ways to store tables in memofields.


Roy Lambert

Roy,

Have you considered exporting the table to a CSV files then importing the CSV file?


--
Richard Harding
Windella Computer Knowhow
28 Freeman Drive
Lochinvar NSW 2321
Phone:    61 2 4930 7336
Mobile:    0419 016 032
email:    rharding@wck.com.au

Roy,

<< I just hope that you're doing it in the same way as DBISAM at the end and
I won't have to worry about structure changing throughout the life of
ElevateDB. If there's much chance of that I might as well start thinking
about alternative ways to store tables in memofields. >>

EDB uses a flexible stream format that isn't wedded to any particular EDB
structures.

--
Tim Young
Elevate Software
www.elevatesoft.com

Richard

Nope because CSV isn't brilliant for handling text containing memo fields let alone ones containing binary.

Roy Lambert

Tim
I think that translates into what I was hoping for.


Roy Lambert