X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EE23B9DCAD7 for ; Wed, 15 Feb 2006 12:24:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58024-02 for ; Wed, 15 Feb 2006 12:24:33 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.201]) by postgresql.org (Postfix) with ESMTP id 7F8C79DCA17 for ; Wed, 15 Feb 2006 12:24:32 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i13so149663wra for ; Wed, 15 Feb 2006 08:24:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=k/9V/RzQURpg2wqJLvqXxoasN5dBNkuc+cD9JDQ9QrrAL8tJSTlbYEuLYJa0tx/Yy++yPLKKeMHlWzKHLP9DR9cV6PbDzNoKcpNd8+xayI27ReTrj5Iq+UvX97IfPf5crdLjfd4OA2/saIDHw2CEjnpcAeWd7fAVFIlDv5si0F8= Received: by 10.65.159.10 with SMTP id l10mr410982qbo; Wed, 15 Feb 2006 08:24:31 -0800 (PST) Received: by 10.65.225.3 with HTTP; Wed, 15 Feb 2006 08:24:31 -0800 (PST) Message-ID: Date: Wed, 15 Feb 2006 12:24:31 -0400 From: Adam Alkins To: pgsql-sql@postgresql.org Subject: Btrieve to PostgreSQL MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/230 X-Sequence-Number: 24240 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