Foxpro nubie: Migrate 2.6 Unix to Windows?

Hello all,

I have a client that has been running an SCO Unix FoxPro 2.6 database and I
would like to migrate it to Windows.

Is it as easy as buying a Windows version of FoxPro and moving the actual
database tables and forms?

I'm prepared to do some work as necessary, but would like to understand the
"got-ya's" before I quote the conversion.

What would be the best version of FoxPro to convert into: Visual, etc.??

I have a good database background, but am unfamiliar with FoxPro.

Any guidance or links to an FAQ would be much appreciated

Thanks in Advance
Ed O'Reilly
oreilly@nospambasici.com (remove the nospam)

Leemi
Fri Dec 26 16:01:05 CST 2003

Hi Ed:

The only versions of FoxPro that are currently supported by Microsoft are
VFP 7.0 and 8.0. Both of these products only run on the Windows platform.

I suggest that you buy VFP 8.0 and then add Service Pack 1. This will give
you the latest version with the most up-to-date features and bug fixes.

To get up-to-speed with VFP, you might want to look at the online training
from these web sites:

http://www.free-ed.net/fr03/lfc/030101/129/default.asp

http://www.takenote.com

You might also want to look at the VFP books available from
www.hentzenwerke.com.

Here are some conversion resources useful when moving FoxPro 2.x code in to
VFP:

Chuck Urwiler's FoxPro Advisor article at:
http://foxproadvisor.com/doc/05239

Also, this is a link to an older white paper on converting from FoxPro 2.x
to VFP 5.0. While the information is a little old, much of it is still
applicable to later versions:

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarfoxgen/
html/msdn_movfox.asp


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003


>Hello all,

>I have a client that has been running an SCO Unix FoxPro 2.6 database and I
>would like to migrate it to Windows.

>Is it as easy as buying a Windows version of FoxPro and moving the actual
>database tables and forms?

>I'm prepared to do some work as necessary, but would like to understand the
>"got-ya's" before I quote the conversion.

>What would be the best version of FoxPro to convert into: Visual, etc.??

>I have a good database background, but am unfamiliar with FoxPro.

>Any guidance or links to an FAQ would be much appreciated

>Thanks in Advance
>Ed O'Reilly
>oreilly@nospambasici.com (remove the nospam)

John
Sat Dec 27 18:10:41 CST 2003

Ed OReilly wrote:

> Hello all,
>
> I have a client that has been running an SCO Unix FoxPro 2.6 database and
> I would like to migrate it to Windows.
>
> Is it as easy as buying a Windows version of FoxPro and moving the actual
> database tables and forms?
>
> I'm prepared to do some work as necessary, but would like to understand
> the "got-ya's" before I quote the conversion.
>
> What would be the best version of FoxPro to convert into: Visual, etc.??
>
> I have a good database background, but am unfamiliar with FoxPro.
>
> Any guidance or links to an FAQ would be much appreciated
>
> Thanks in Advance
> Ed O'Reilly
> oreilly@nospambasici.com (remove the nospam)
The source requires CR and LF convert for windows.
John
--
John Fabiani

Sikandar
Mon Dec 29 00:06:18 CST 2003

hi, "Ed OReilly"
i am sikandar ali
from pakistan
it is so simple to do this transfer
just needs a simple floppy diskket
you are required to copy all the databases or tables u
want to migrate or copy to in the floppy diskket.
and use any of the visual foxpro version best 6.0 or
latest these version automatiocally can convert the file
formates at first use and will prompt u or querries u to
tell that which format u want to chang.it automatically
converts it also provides support to dbase type table
formats.
thanks for asking help
tell me if u need any more help
mail to me at
wisemen515@india.com
thanks
sikandar ali
from pakistan

Dan
Mon Dec 29 11:36:40 CST 2003

Your answer is "it depends".

In theory, if you can find an old copy of FoxPro 2.6/Windows you SHOULD be
able to just convert from FPU (character-based) to FPW. HOWEVER, be aware
that a whole cottage industry developed writing articles about the gotchas
in this cross-platform fallacy. It may not go as easily as you'd expect.

And, of course, then you'd be running an application that hasn't been
supported (i.e. has been discontinued) for a good number of years.

A far better option would be to re-write the app in VFP. In the end, you'll
end up with something more usable and stable and it willl actually take you
less time.

Dan


"Ed OReilly" <eoreilly@nospambasici.com> wrote in message
news:gr0Hb.206364$_M.913443@attbi_s54...
> Hello all,
>
> I have a client that has been running an SCO Unix FoxPro 2.6 database and
I
> would like to migrate it to Windows.
>
> Is it as easy as buying a Windows version of FoxPro and moving the actual
> database tables and forms?
>
> I'm prepared to do some work as necessary, but would like to understand
the
> "got-ya's" before I quote the conversion.
>
> What would be the best version of FoxPro to convert into: Visual, etc.??
>
> I have a good database background, but am unfamiliar with FoxPro.
>
> Any guidance or links to an FAQ would be much appreciated
>
> Thanks in Advance
> Ed O'Reilly
> oreilly@nospambasici.com (remove the nospam)
>
>
>
>

Ed
Tue Dec 30 07:27:58 CST 2003

Thanks for all your input, it has been a great help. Not exactly sure what
I'm going to do, but you'll probably see more questions from me in the
future.

Ed
"Ed OReilly" <eoreilly@nospambasici.com> wrote in message
news:gr0Hb.206364$_M.913443@attbi_s54...
> Hello all,
>
> I have a client that has been running an SCO Unix FoxPro 2.6 database and
I
> would like to migrate it to Windows.
>
> Is it as easy as buying a Windows version of FoxPro and moving the actual
> database tables and forms?
>
> I'm prepared to do some work as necessary, but would like to understand
the
> "got-ya's" before I quote the conversion.
>
> What would be the best version of FoxPro to convert into: Visual, etc.??
>
> I have a good database background, but am unfamiliar with FoxPro.
>
> Any guidance or links to an FAQ would be much appreciated
>
> Thanks in Advance
> Ed O'Reilly
> oreilly@nospambasici.com (remove the nospam)
>
>
>
>