Is there a free software to convert .dbf to .sql tables ?

[janak vyas]

I wanted to convert the .dbf in MySQL Workbench.
Is there a way to convert the .dbf directly on the MySQL workbench ? or is there a free software for the conversion ?

 

[Mike Lewis]

You don't need a tool to do this. You can simply copy the DBF data to a CSV file, which MySQL can then import natively.

Note that the data is stored in MySQL, not MySQL Workbench. The Workbench is a development environment, not a database.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[GriffMG]

How does that deal with memos?

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Mike Lewis]

Janak,

Does your data have memo fields?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[janak vyas]

No, it doesn't.

 

[Mike Lewis]

In that case, you can do as I suggested.

But there are other options. One alternative would be to download a MySQL ODBC driver, which would enable VFP to read and write directly from and to MySQL tables. But be aware that, whatever solution you adopt, it won't be completely seamless. The chances are that there will be issues with data types, NULL support and the like. That applies to all database conversions, and is not specific to MySQL.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Chris Miller]

Theres the VFP upsizing wizard. I'd use the VFPX version of it:

https://github.com/VFPX/UpsizingWizard

It's mainly intention is to move from DBF to SQL Server, but it could be adapted to MySQL, if it's not already an option.
Or you use it as is to create a SQL Server database and then go to MySQL from there.

Chriss

 

[ROGERIORIOS]

Select the table DBF...

Connect to mysql..

Use the copy structure extend to ... use the .dbf table structure and create your commands to create the fields ( name, type ..) field_type,
field_name,field_len...
Use mysql information_schema to check if the table already exists..
Check if there are indexes and primary keys in the dbf, if there is, send an update in the table structure in mysql. Then read the records from your table and insert them into mysql.