Re: Data Migration Methodologies -- FoxPro to Access

You should be able to link from Access to the FoxPro tables and use queries to insert the data into the new tables.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Koronis Rift" <foo_at_bar.com> wrote in message
news:um9q2tn9da9ude_at_corp.supernews.com...


> (Crossposted to: comp.databases.theory,


microsoft.public.access.conversion)


>

> Am just beginning to undertake a rather large[1] data migration/data


> conversion project, moving from an off-the-shelf customer information

system


> to a custom-built one. Current system uses Visual FoxPro (appx. 230


tables),


> new system uses Access 97 (appx. 80 tables).


>

> The Problem: New database was designed "from scratch", solely from the

> enterprise data model. The existing database schema was not evaluated at

all


> for the purposes of migrating the legacy data to the new system. Thus, my


> question.

>

> I am looking for the following:

> 1. General info on data migration methodology (comp.databases.theory)

> 2. Tips specific to FoxPro/Access regarding the mechanics of migration

> (microsoft.public.access.conversion)

>

> What I have found already:

> - "The Complete Data Migration Methodology", Joseph Hudicka

> - "The Five Legacy Data Contaminants You Will Encounter In Your Warehouse

> Migration", Vality Technology, Inc.

> - "Avoid Data Migraines During Data Migration", Christine Raker and Robert

> Knowlton

>

> Any tips, links, articles, white papers, jokes, war stories, etc... would

be


> greatly appreciated! (No need to crosspost replies, I'll track the thread


in


> both newsgroups)


>

> --

> [1] Well, not huge databases -- but large in the sense that it's just

myself


> and a contractor working on the migration.


>

> --

> Koronis Rift

> "Reply To" Address Will Not Work

> Just Use The Newsgroup

> And Have A Nice Day

>

>