Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Migrating from Foxpro 2.6a to SQL Server

0 views
Skip to first unread message

oscardex2k

unread,
Nov 4, 2002, 6:05:22 PM11/4/02
to
Hello All,

I'm looking to migrate data from DBFs (Foxpro DOS 2.6a) to SQL Server.
I read somewhere on this news group (by Rick/rgbean) that the latest
Microsoft VFP driver (http://msdn.microsoft.com/vfoxpro/downloads/odbc.asp)
will work with all 2.x tables. Does that hold true for DOS-based DBFs too
(I'm assuming that the structure of the DBFs changed between 2.6a DOS and
2.6a Windows)

Pls advise,
oscar

Rick Bean

unread,
Nov 4, 2002, 7:13:12 PM11/4/02
to
Oscar,
No, there was really no difference between FPD and FPW .DBFs. The lastest
VFP ODBC driver works fine on ANY .DBF. The only exception I'm aware of is
if the table was created by Clipper with more than 255 fields (a true
non-standard DBF).

Rick

"oscardex2k" <oscar...@yahoo.com> wrote in message
news:#yNSLaFhCHA.2700@tkmsftngp09...

oscardex2k

unread,
Nov 4, 2002, 10:03:30 PM11/4/02
to
thanks. what's would the recommended procedure be for extracting data out of
FPD2.6a DBFs and importing them into SQL Server.
I was thinking...SQL Server DTS...using FPD ODBC Driver. Any better ideas ?

thanks,
Sunny


"Rick Bean" <rgb...@NOSPAMmelange-inc.com> wrote in message
news:#qANw$FhCHA.1324@tkmsftngp11...

Bonnie Berent

unread,
Nov 5, 2002, 12:12:38 AM11/5/02
to
Oscar,

DTS can sometimes be a bit of a pain, but if you're familiar enough with it,
I think it's a good solution for converting your FPD tables.


~~Bonnie


"oscardex2k" <oscar...@yahoo.com> wrote in message

news:uv0uBfHhCHA.2324@tkmsftngp08...

oscardex2k

unread,
Nov 6, 2002, 1:55:24 PM11/6/02
to
what would the alternative be, Bonnie ?

"Bonnie Berent" <bon...@profitware-online.com> wrote in message
news:Osn3PoIhCHA.1864@tkmsftngp11...

Bonnie Berent

unread,
Nov 7, 2002, 1:21:57 AM11/7/02
to
Oscar,

Alternatives? Why? I thought you wanted to know if DTS would work and I said
yes it would. And I think it's probably the easiest (as long as you're
familiar with DTS ... it has it's quirks). But, if you want alternatives,
you can "roll your own" with VFP (which can read the FPD tables just fine),
and then write a bunch of code to pull the data out of the .dbfs and insert
them into the SQL Server tables using SQLSMO or just SPT, whatever.

As far as which method is better, I dunno ... it's probably six of one, half
dozen of the other. =)


~~Bonnie


"oscardex2k" <oscar...@yahoo.com> wrote in message

news:OMmWnXchCHA.1688@tkmsftngp09...

0 new messages