B.2 Converters

• http://www.mysql.com/Downloads/Contrib/mssql2mysql.txt Converter from MS-SQL to MySQL. By Michael Kofler. The mssql2mysql home page is at http://www.kofler.cc/mysql/mssql2mysql.html.
• http://www.mysql.com/Downloads/Contrib/dbf2mysql-1.14.tar.gz Convert between `.dbf' files and MySQL tables. By Maarten Boekhold (boekhold@cindy.et.tudelft.nl), William Volkman, and Michael Widenius. This converter includes rudimentary read-only support for MEMO fields.
• http://www.mysql.com/Downloads/Contrib/dbf2mysql-1.13.tgz Convert between `.dbf' files and MySQL tables. By Maarten Boekhold, boekhold@cindy.et.tudelft.nl, and Michael Widenius. This converter can't handle MEMO fields.
• http://www.mysql.com/Downloads/Contrib/dbf2mysql.zip Convert between FoxPro `.dbf' files and MySQL tables on Windows. By Alexander Eltsyn, ae@nica.ru or ae@usa.net.
• http://www.mysql.com/Downloads/Contrib/dbf2sql.zip Short and simple prg that can help you transport your data from foxpro table into MySQL table. By Danko Josic.
• http://www.mysql.com/Downloads/Contrib/dump2h-1.20.gz Convert from mysqldump output to a C header file. By Harry Brueckner, brueckner@mail.respublica.de.
• http://www.mysql.com/Downloads/Contrib/exportsql.txt A script that is similar to access_to_mysql.txt, except that this one is fully configurable, has better type conversion (including detection of TIMESTAMP fields), provides warnings and suggestions while converting, quotes all special characters in text and binary data, and so on. It will also convert to mSQL v1 and v2, and is free of charge for anyone. See http://www.cynergi.net/exportsql/ for the latest version. By Pedro Freire, support@cynergi.net. Note: Doesn't work with Access2!
• http://www.mysql.com/Downloads/Contrib/access_to_mysql.txt Paste this function into an Access module of a database that has the tables you want to export. See also exportsql. By Brian Andrews. Note: Doesn't work with Access2!
• http://www.mysql.com/Downloads/Contrib/importsql.txt A script that does the exact reverse of exportsql.txt. That is, it imports data from MySQL into an Access database via ODBC. This is very handy when combined with exportsql, because it lets you use Access for all DB design and administration, and synchronise with your actual MySQL server either way. Free of charge. See http://www.netdive.com/freebies/importsql/ for any updates. Created by Laurent Bossavit of NetDIVE. Note: doesn't work with Access2!
• http://www.mysql.com/Downloads/Contrib/mdb2sql.bas Converter from Access97 to MySQL by Moshe Gurvich.
• http://www.mysql.com/Downloads/Contrib/msql2mysqlWrapper-1.0.tgz A C wrapper from mSQL to MySQL. By alfred@sb.net
• http://www.mysql.com/Downloads/Contrib/sqlconv.pl A simple script that can be used to copy fields from one MySQL table to another in bulk. Basically, you can run mysqldump and pipe it to the sqlconv.pl script. The script will parse through the mysqldump output and will rearrange the fields so they can be inserted into a new table. An example is when you want to create a new table for a different site you are working on, but the table is just a bit different (that is - fields in different order, etc.). By Steve Shreeve.
• http://www.mysql.com/Downloads/Contrib/oracledump Perl program to convert Oracle databases to MySQL. Has same output format as mysqldump. By Johan Andersson.
• http://www.mysql.com/Downloads/Contrib/excel2mysql Perl program to import Excel spreadsheets into a MySQL database. By Stephen Hurd shurd@sk.sympatico.ca
• http://www.mysql.com/Downloads/Contrib/T2S_100.ZIP. Windows program to convert text files to MySQL databases. By Asaf Azulay.

User Comments

The dbf2mysql converter does not handle numeric data very well. All data are stored in MySQL INT attributes. Since numeric fields may be up to 20 characters long, clipping is a dangerous possibility (signed INTs hold -2147683648 - 2147483647; larger values will be stored as 2147483647).

I've written a patch which causes dbf2mysql v1.14 to use the full range of MySQL integer data types (TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT) where appropriate. Please note that a signed BIGINT can only hold -9223372036854775808 - 9223372036854775807. So, values in the range 9223372036854775808 - 99999999999999999999, inclusive, will be stored as (2^63 - 1).

The patch is available at http://www.joshdrew.com

Add your own comment.