Re: dBase 3 to FoxPro or ???

From: YD (yd.techHAT_at_techie.com)
Date: 11/16/04


Date: Tue, 16 Nov 2004 20:18:34 -0300

On Mon, 15 Nov 2004 06:57:08 GMT, Robert Baer
<robertbaer@earthlink.net> wrote:

>Tim Shoppa wrote:
>>
>> Robert Baer <robertbaer@earthlink.net> wrote in message news:<419091B0.82C58320@earthlink.net>...
>> > I have a dBASE 3 application that must remain in true, pure DOS
>> > (Windows not allowed even if quiet).
>> > The size of the database files is getting large and dBASE is slowing
>> > down, and at times "stutters".
>> > Does anyone have FoxPro for DOS or any other decent database language
>> > for DOS (ie: Paradox is excluded)?
>>
>> It depends on what you're doing in dBase3, but the most logical rehosting
>> to modern tools would probably be either to a BerkeleyDB implementation
>> (good for embedded stuff where the database is accessed in the same way
>> over and over again) or to a free SQL implementation (good for when a
>> wide variety of queries are run) like mySQL.
>>
>> BerkeleyDB: http://www.sleepycat.com/
>> MySQL: http://www.mysql.com/
>>
>> Since you say Windows isn't allowed I won't go into all the evils of
>> MS Access and why you should never ever touch it :-).
>>
>> Tim.
>
> Thanks for giving the possibility; sending a query to them for more
>pertinet info.

Go Linux and MySQL. You can export the dBase files as tab separated
text files and import them to MySQL. I've done it in DOS/Win without
too much of a hassle except for getting the syntax just right on both
sides. Those were rather small files, at most a couple thousand
entries, so I can't say what happens when they exceed humongous.

Linux isn't that hard to get to grips with, especially as you won't be
using the GUI. FreeBSD is better documented, has all the needed apps
and is optimised for servers. Install PHP and Apache for a web
interface to the database, use Samba to set up a file server on a
Microshaft Network.

- YD.

-- 
Remove HAT if replying by mail.


Relevant Pages

  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • Re: wich database
    ... I plan to switch from an old database to a new one. ... I need security, speed and low cost. ... MySQL is an excellent choice. ... Do you WANT to use Linux? ...
    (comp.databases)
  • Re: Filemaker/Access Linux alternative
    ... For your database, you should consider MySql. ... of that for Linux. ... > Filemaker and my partner access. ...
    (comp.os.linux.misc)
  • Re: applications
    ... > I've taken a 2 day Linux Admin course, and know just about that much. ... database with good connectivity and some **nifty** RAD/GUI tools. ... Database servers include PostgreSQL and MySQL. ... I recommend PostgreSQL on FreeBSD over either ...
    (freebsd-questions)
  • Re: Database Recommendations
    ... >> for that small database, mysql would be just fine. ... > Is there a way to convert an existing Access data base to mysql or ... Linux 2.4.10-4GB ...
    (alt.os.linux.suse)