4/26/2018 How to convert Visual Foxpro database into SQL Server database - Stack Overflow
How to convert Visual Foxpro database into SQL Server database Ask 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....
sql sql-server sql-server-2008 foxpro visual-foxpro
edited May 29 '13 at 18:21 asked May 29 '13 at 16:56
marc_s Rai Micheal
536k 119 1040 55 2 5 10
1204
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 May
29 '13 at 17:08
1 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 May 29 '13 at
18:22
2 Answers
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)
https://stackoverflow.com/questions/16819811/how-to-convert-visual-foxpro-database-into-sql-server-database 1/3
4/26/2018 How to convert Visual Foxpro database into SQL Server database - Stack Overflow
Join Stack Overflow to learn, share knowledge, and build your career. Email Sign Up OR SIGN IN WITH Google Facebook
3.Choose Data provider for ODBC as data source
4.Map and import your data
edited Jan 7 '15 at 13:25 answered May 29 '13 at 18:42
Andrey Morozov
https://stackoverflow.com/questions/16819811/how-to-convert-visual-foxpro-database-into-sql-server-database 2/3
4/26/2018 How to convert Visual Foxpro database into SQL Server database - Stack Overflow
6,076 5 36 59
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 '13 at 15:09 answered May 30 '13 at 1:57
Esparta Palma
535 3 9
https://stackoverflow.com/questions/16819811/how-to-convert-visual-foxpro-database-into-sql-server-database 3/3
