Subject | Re: BTrieve to Firebird Data Migration. |
---|---|
Author | Ali Gökçen |
Post date | 2005-07-04T14:13:16Z |
Hi,
there is no easy way to resolve btrieve file record structer.
Btrieve record manager doesn't interested with record structer and
doesn't know anything about fields or field names or types.
It stores only n bytes(record size) to a file with defined indices
using page memory management system. The application only knows
everything about structer. Btrieve can reports only keyfield
positions and types. But there is a lot of integer, float, date,
time, char etc. fields in structers.
You should do reverse engineering on application to solve structer.
Or you can try to reach lost programmer to get structer headers.
Or you can enter some test values step-by-step to find out field
positions and possible types..
Good luck,
Ali
--- In firebird-support@yahoogroups.com, "R. S. Patil"
<kpr_rspatil@s...> wrote:
there is no easy way to resolve btrieve file record structer.
Btrieve record manager doesn't interested with record structer and
doesn't know anything about fields or field names or types.
It stores only n bytes(record size) to a file with defined indices
using page memory management system. The application only knows
everything about structer. Btrieve can reports only keyfield
positions and types. But there is a lot of integer, float, date,
time, char etc. fields in structers.
You should do reverse engineering on application to solve structer.
Or you can try to reach lost programmer to get structer headers.
Or you can enter some test values step-by-step to find out field
positions and possible types..
Good luck,
Ali
--- In firebird-support@yahoogroups.com, "R. S. Patil"
<kpr_rspatil@s...> wrote:
> Hello Friends,
>
>
> One of our prospectives have a legacy application
> using Btrieve Data Engine. The developer is untraceable
> so they want a new system. We suggested FireBird - Delphi
> Combination and has been approved new system will be
> legacy + some features. But they want all old data to be
> migrated from btrieve to Firebird with newly added fields
> with some default data. They do not know database Structure
> also. We also are not conversant with BTrieve, nor we know
> tools to use for data browsing and knowing structures.
>
> Can somebody suggest me how shall we proceed, which tools
> shall we use and is there any free BTrieve Engine
> to be used on Windows/Linux ?
>
> Thanks and Best Regards
>
> R. S. Patil