All geek questions in one place

How to convert a Visual Foxpro database to a SQL Server database

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

Does anyone know how to do this? Please give me a solution.

Thanks in advance....

+6
source share
2 answers

Try the following:

1.Create an ODBC data source in a DBF file

enter image description here

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

enter image description here

3.Select the Data Provider for ODBC as the data source.

enter image description here

4.Map and import your data

enter image description here

+10
source

You can use the “Update Wizard” from the Visual FoxPro program, which is located in the Tool Wizard → Wizards → Acceleration.

If you try this, remember two things:

  • You need to add DBF to the database container (this is a safe procedure: create a new database and add tables). BACKUP , this file can no longer be used as a "Free table". Again, talking about data is a safe thing.
  • You may need this in a 32-bit concern, AFAIK there is no 64-bit ODBC driver for DBFs o VFP databases. And the Upsizing Wizard does not work for OLEDB.

More on this in this article in KB: HOWTO: How to Use the Upsizing (SQL) Wizard in Visual FoxPro

Edit:

I completely forgot the advanced Improvement Wizard in Visual FoxPro 9 SP2, this is better: (VFP) Simplified Simplified

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

+5
source

Source: https://habr.com/ru/post/946106/

More articles:


All Articles