foxpro to SQL Server conversion

[Dan Duda]

I'm new to SQL Server and need to convert a Fox Pro 2.6 database to SS.
What's the best way to go about doing this? From what I've read it looks
like the BCP command would have to be used on each table. Thanks for any
advice.

Dan

[Geoffrey M. Inget]

When I last did this, I weighed two possible options..

(I am assuming here that the table structures are already in place on SQL
Server and your data in the Fox tables is of the same structure)
(Also, I am assuming you can do the same things with 2.6: I did this using
Fox 5.0)

1) Use BCP. Why didn't I do it? Inexperience, for one. I also know that
it becomes more complicated if you are converting Memo fields in FoxPro. I
didn't have time to investigate or try much with this. A big plus that I
believe to be true for BCP is that it is lightning-quick. I have seen BCP
work and can confirm it is very fast.

2) Create an ODBC connection to the SQL Database on the workstation you are
going to migrate from. Establish a connection from FoxPro to SQL Server
with the ODBC Connection. For each table on SQL you want to migrate to,
scan through the table and use the values to insert the rows into SQL using
an INSERT pass-through command. This was the method I used, but it was
pretty pathetically slow. I just decided it was OK because it was
one-time-and-out and there weren't huge numbers of rows to migrate, I think
the largest Fox table had 80,000 rows.

Hope this helps, a little.

Dan Duda <dan...@mindspring.com> wrote in article
<6qn7a0$8td$1...@camel29.mindspring.com>...