Unless the the purchased company has a Pervasive DB engine you can use, there is the option of downloading a 30-day evaluation copy of the workgroup engine directly from the source.

Then you can use DBI and DBD::ODBC to access the database, works pretty well IMHO. You can open connections simultanously to the purchased database and your current database, hence moving data in one step.

The only cinch is that you need the database description files (.DDF) to be able to use the SQL interface. Otherwise you will have to resort to dumping table data to disk using the BUTIL utility, and then use perl and substr | unpack to parse the asciifiles, yuck.

So, check if the purchased company used the MKDE interface(bad for you) or the SRE (good for you) before anything else.

Update:
Changed CPAN links.

In reply to Re: Btrieve Code by guha
in thread Btrieve Code by Poetic Justice

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.