Restoring a FoxPro database backup?

Cindy Winegarden

2005-11-10 21:48:30 UTC

Hi Evan,

FoxPro is a file server database, so a "backup" is just an XCopy of the
files. Fox tables come in three pieces: the DBF file is the table itself,
the CDX file (optional) is the index, and the FPT file (optional) holds the
contents of Memo fields if there are any. The BAK files are leftovers from
changing table structures and you won't need them. The FoxUser.* files are
"resource" files that keep track of things like the last position of a
window, so you won't need those either. When you access a DBF the Fox data
engine takes care of using the CDX and FPT if they're there, so you won't
have to do anything special with them.

From there you can use either ODBC or OLE DB and any of the various ways SQL
Server has to import "foreign" data. The ODBC drivers and OLE DB data
provider are downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates .

I assume you're using SQL 2000. You can use Data Transformation Services
(Tools > Data Transformation Services) and let the Wizard guide you through
importing the data.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
***@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

Post by Evan Nelson
I have received what I believe to be a backup of a FoxPro database. I have
never worked with FoxPro but I'm pretty sure that this is what I received
because in Windows Explorer it says the file type is "Microsoft Visual FoxPro
table". I have several .dbf files, a FOXUSER.dbf, FOXUSER.FPT, and a .Bak
file.
I eventually need to import this data into a SQL Server database. Can
anyone tell me how I can do this or point me to somwhere with info on how to
do this?
Thank you,
Evan Nelson