Re: Btrieve to SQL

Adam Alkins wrote:
> Hey,
>
> Been looking around to do this for a while, haven't gotten concrete
> information. I'm interested in taking data from Peachtree Accounting
> 2003 (Which is stored Btrieve DAT files) and importing them into a
> Postgres SQL database. I have looked around on the net about this, but
> haven't gotten any concrete methods on doing this. Figured with
> Pervasive's involvement in PostgreSQL, might have some luck on this
> list.
>
Use Perl :)

http://search.cpan.org/~dlane/

Which will get you access to the files and then Perl-DBI/DBD to
push into PostgreSQL.

Sincerely,

Joshua D. Drake

> Peachtree also stores the DDL (Dictionary) files for the Btrieve
> database in the directory. I'm not sure what version of Btrieve the
> files are. Does anyone have any experience in doing this? I read
> somewhere about Pervasive's SDK for their DB server which can convert
> Btrieve files to SQL (or something like that), but looking through the
> SDK and documentation, haven't found any real information. This is
> just an experimental project, so any commercial solutions to do this
> really doesn't apply.
>
> Regards,
>
> --
> Adam Alkins
> http://www.rasadam.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/