Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
Migrating tables in memo fields |
Fri, Jan 4 2008 6:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Jan 4 2008 7:58 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Jan 4 2008 8:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Jan 7 2008 4:23 PM | Permanent Link |
Richard Harding | 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 |
Mon, Jan 7 2008 7:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jan 8 2008 3:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Richard
Nope because CSV isn't brilliant for handling text containing memo fields let alone ones containing binary. Roy Lambert |
Tue, Jan 8 2008 3:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I think that translates into what I was hoping for. Roy Lambert |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |