How to convert Visual Foxpro database into SQL Server database

Try the following steps:

1.Create ODBC Data Source to DBF file

2.Using SQL Server Import Data Wizard (right click to database in the SSMS)

3.Choose Data provider for ODBC as data source

4.Map and import your data

You can use the "Upsizing Wizard" from the Visual FoxPro program, it's located on Tools -> Wizards -> Upsizing Wizard.

If you try this keep on mind two things:

• You need add the DBFs to a Database Container (it's a safe procedure: create a new Database and ADD the tables). BACKUP, those file can't be used as a "Free table" anymore. Again, talking about data is secure thing.
• You may need this into a 32bit concern, AFAIK there is no 64 bits ODBC driver for DBFs o VFP Databases. And the Upsizing Wizard don't work for OLEDB.

See more about it in this KB article: HOWTO: How to Use the Upsizing (SQL) Wizard in Visual FoxPro

Edit:

I totally forgot the improved Upsizing Wizard in Visual FoxPro 9 SP2, it's way better: (VFP) Upsizing Simplified

Edit2: This could help: How to use SQL Server 2005 Integration Services (SSIS) to import Visual FoxPro data into SQL Server.