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....
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....
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:
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.