Re: Visual FoxPro (VFP) 9 Migration Strategy to Postgresql on Linux

Fredag 13. april 2012 17.41.41 skrev Kevin Salisbury :
> We are in the early stages of planning a migration of all our VFP 9
> databases to Postgresql. Our VFP dbc contains roughly 300 tables and 8GB
> total data. Screen replacements are likely going to be HTML5/CSS3 based
> and report replacements will likely be one of the open source BI reporting
> portals. While we know VFP very well, and we use a LOT of linux elsewhere
> in the company - we know very little about Postgres. We do see a lot of
> tutorials out there for new Postgres databases, but not much in the way of
> migration from VFP. We're curious to know if anyone else has gone through
> a similar migration that may have some advice on how to get started.

The most important step is to get a thorough grip on PostgreSQL, and
understand what it can do for you. With a clear grasp of concepts such as
transactions and foreign key constraints, you'll probably find it far easier to
implement your business logic with a PostgreSQL database than dirty ol'
FoxPro. On the other hand, you're much more on your own wrt the interface.

On a far smaller scale than your project, I migrated my genealogy database
from a commercial FoxPro program to my own homegrown PostgreSQL/PHP
application. You can read about it here:

http://solumslekt.org/forays/

> NOTICE:
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual(s) or entity to whom
> they are addressed. If you have received this email in error please
> notify the sender and delete all copies on your system. Please
> note that any views or opinions presented in this email are solely
> those of the author and do not necessarily represent those of Twin
> Manufacturing Company, Inc.

That is a rather silly thing to tell an email list.

regards, Leif
http://code.google.com/p/yggdrasil-genealogy/