How to convert Visual Foxpro database into SQL Server database

Question

One of my clients has a Foxpro database (.DBF file). I need to convert it into a SQL Server 2008 database.

Does anyone have any idea how to do this? Kindly give me solution.

Thanks in advance....

You may want to look at setting up a linked server. some info here serverfault.com/questions/361226/… and msdn.microsoft.com/en-us/library/ms188279.aspx — Ian Kenney
– Ian Kenney, Commented May 29, 2013 at 17:08
Should be pretty easy with the SQL Server Integration Services - just open the .dbf file, transfer the data over into a SQL Server database table - done! — marc_s
– marc_s, Commented May 29, 2013 at 18:22

Andrey Morozov · Accepted Answer · 2015-01-07 13:25:33Z

18

Try the following steps:

1.Create ODBC Data Source to DBF file

enter image description here

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

enter image description here

3.Choose Data provider for ODBC as data source

enter image description here

4.Map and import your data

enter image description here

edited Jan 7, 2015 at 13:25

answered May 29, 2013 at 18:42

Andrey Morozov

8,0275 gold badges59 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Esparta Palma · Accepted Answer · 2013-06-05 15:09:19Z

8

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.

edited Jun 5, 2013 at 15:09

answered May 30, 2013 at 1:57

Esparta Palma

7455 silver badges10 bronze badges

2 Comments

Douglas Gaskell Over a year ago

How do you get access to FoxPro? I'm stuck with a database and no way to access FoxPro to open it....

MicroservicesOnDDD Over a year ago

@DouglasGaskell - Visual Studio Subscription has it, last time I was subscribed, about a year ago.

Collectives™ on Stack Overflow

How to convert Visual Foxpro database into SQL Server database

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related