Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: PACO TERRADO
  Where is PACO TERRADO?
 manila
 Philippines
 PACO TERRADO
 Tags
Subject: RE: old foxpro database
Thread ID: 78721 Message ID: 78746 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, October 07, 2005 3:42:35 PM         
   


> hi experts,
>
> i have a question regarding tables! i'm upgrading my applications from foxpro for dos to vfp the thing is how can preserve my dos version database in order form me to upgrade my applications and at the same time i can still access my old databases from my foxpro for dos programming language? is it posible? if not is thier any tricks that i can do to attain my objectives?
>
> thanks alot!!!(",)


Paco,
When ever I create a new version of an app (major revision) I typically start the programming phase with a data migration utility. Typically, I will run this utiliity at night (after the users are off of the data) giving me an exact copy of the current database but in the new data format.

The primary advantage to writing this data conversion utility is that the users can do beta testing for me using real data (yesterday's) and when we are satisfied, the switch over to the new app is as simple as turning off the old system.

Another advantage of this method is that you preserve the old data in a new format. The old database is left intact, but is no longer used. I typically create a couple of CD backups of the old database and save them in two different offsite backup stores. If I ever need them, I can get at them.

Ken

ENTIRE THREAD

old foxpro database Posted by PACO TERRADO @ 10/7/2005 8:57:54 AM
RE: old foxpro database Posted by John Weller @ 10/7/2005 10:12:46 AM
RE: old foxpro database Posted by ShadowFox @ 10/7/2005 10:18:48 AM
RE: old foxpro database Posted by John Weller @ 10/7/2005 6:44:16 PM
RE: old foxpro database Posted by Ken Murphy @ 10/7/2005 3:42:35 PM
RE: old foxpro database Posted by Ken Murphy @ 10/7/2005 9:48:49 PM