|
Home > Archive > FoxPro database connector > November 2005 > Restoring a FoxPro database backup?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Restoring a FoxPro database backup?
|
|
| Evan Nelson 2005-11-10, 8:25 pm |
| 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
| |
| Cindy Winegarden 2005-11-10, 8:25 pm |
| 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
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Evan Nelson" < EvanNelson@discussio
ns.microsoft.com> wrote in message
news:9AE4C8A0-1C56-408F-B7B1- 267A06C67F51@microso
ft.com...
>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
|
|
|
|
|