How to convert Visual Foxpro database into SQL Server database

sql sql-server sql-server-2008 foxpro visual-foxpro
Rai Micheal picture Rai Micheal · May 29, 2013 · Viewed 51.8k times · Source

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

Answer

Andrey Morozov picture Andrey Morozov · May 29, 2013

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

Related questions

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More
Rename column SQL Server 2008

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL. ALTER TABLE table_name RENAME COLUMN old_name to new_name; This statement doesn't work.

Read More