According to http://filext.com/alphalist.php?extstart=^P I think they are Pegasus Databases (pdb) and Pegasus Mail Something (pnx).
I would have the same suggestion as Nate Lowry, use SQLAlchemy, but would suggest you its SQLSoup extension. The extra work you'd have to do is to create the appropriate Pegasus engine, but I don't know how much work that represents. If you already know how to extract data from it, I suggest extracting it to CSV and loading from CSV. This way you can also read your data in a spreadsheet, just in case. Cheers, Y.Chaouche --- On Thu, 10/28/10, Fraser Burns <[email protected]> wrote: > From: Fraser Burns <[email protected]> > Subject: Re: [dabo-users] MySQL > To: "Dabo Users list" <[email protected]> > Date: Thursday, October 28, 2010, 12:53 PM > John Fabiani wrote: > > On Thursday, October 28, 2010 06:15:25 am Paul McNett > wrote: > > > >> On 10/28/10 2:24 AM, Fraser Burns wrote: > >> > >>> We have need to extract the info out of a > proprietry database and > >>> transfer it to MySQL. Because the are quite a > number of tables we want > >>> to dynamically extract the field names from > the existing base(they are > >>> stored inside the file) and allocate those > same names to the create > >>> stage and then loading the data in. > >>> > > It's not to hard to write a Dabo database > interface. If there is a DB-API 2.0 > > interface to the database then the Dabo interface can > be written. There are > > special cases out there that may prove a problem > (recent pymssql comes to > > mind). But in general it is not to hard. > > > > So what is the proprietry database in question? > > > > Johnf > > > > > They are saved as *.pdb and *.pnx files. Not finding > anything to match > up to them, we have already spent the time and learnt how > they are > assembled. So extraction has had the back broken. > The other databases we often need to interact with are > Paradox, and > there doesn't seem to be much there either. > -- Fraser Burns > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users > Searchable Archives: http://leafe.com/archives/search/dabo-users > This message: > http://leafe.com/archives/byMID/[email protected] > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
