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.

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@postgresql.org so that your
message can get through to the mailing list cleanly

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@postgresql.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/


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

If you need to extract your data you can take a look at BtSearch at
www.nssdd.com. It allows you to export your data to dbase or ascii
formats which you can then import into about anything else.

Gil