Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 Tags
Subject: RE: How to access PC Express files, “filename.DB”?
Thread ID: 104374 Message ID: 104476 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, August 16, 2006 10:02:54 PM         
   


> > > Anybody has experience using foxpro to access data from Personal Express files? Is it possible to convert “.DB” files to foxpro tables?
> > >
> > > Any input is highly appreciated.

> >
> >
> > Hi,
> > I am assuming you are referring to a Personal Express database?
> > If so not directly! You need to take the data out to
> > a CSV file:
> >
> > 1. Load up Personal Express and 'attach' the database you wished to export from.
> > 2. Choose the objects (variables, dimensions etc) in the database you wish to export by using commands such as LISTNAMES and DSC to query the data dictionary.
> > 3. Use the OUTFILE command to send output to your CSV file.
> > 4. Write a procedure to take each variable, loop through all the combination of dimension values attached to it, and use the ROW command to output the values of the variable.
> > 5. Now write the VFP code to import the CSV table into
> > tables that you created to contain the columns in the CSV
> > file.
> >
> > As you probably already know the way data is stored in
> > a Personal Express darabase is not at all like what
> > we are use to with a relational database like SQL-Server.
> >
> > Pete from the Great White North. (Only in Canada, ay.) Over and Out ...

>
> Pete,
>
> Thank you. Yes, I am talking about Personal Express (very old) that is still in use.
>
> At the moment there are several databases and there are about 50,000 lines in the command code. So, it looks not promising to apply foxpro here.
>
> As far as I learned, there is an option to upgrade it to Oracle Express.
> Do you have any experience, recommendations or opinions in this regard?



Hi,
First off is this a web type app?
If so you probably have to go with Oracle 9i, or greater.
If you could provide me a bit more on what this porting is going from
and going to this would help.
Also, is this just a data porting exercise?
I do not know how much background you have in Oracle, so this makes
it tuff as to how much detail you may need?
Full blown versions of Oracle starting with v.8.1.5 support the Oracle exp utility and will export all to a dump file. You can then on a new Oracle
box:
1. Create the new Oracle instance.
2. And import the entire thing with one command and this brings in the
tables, the data, the stored procs, etc...

In your case, with this old version of Personal Express, you are not so
lucky.

Pete from the Great White North. (Only in Canada, ay.) Over and Out ...

ENTIRE THREAD

How to access PC Express files, “filename.DB”? Posted by Yuri Rubinov @ 8/15/2006 6:04:52 PM
RE: How to access PC Express files, “filename.DB”? Posted by Pete Sass @ 8/15/2006 7:59:41 PM
RE: How to access PC Express files, “filename.DB”? Posted by Yuri Rubinov @ 8/15/2006 8:22:34 PM
RE: How to access PC Express files, “filename.DB”? Posted by Pete Sass @ 8/16/2006 10:02:54 PM
RE: How to access PC Express files, “filename.DB”? Posted by Yuri Rubinov @ 8/16/2006 10:27:03 PM
RE: How to access PC Express files, “filename.DB”? Posted by Pete Sass @ 8/16/2006 11:00:35 PM