数据库>> mdb2mysql>> 返回
项目作者： UrsaDK

项目描述 ：
A tool to convert Microsoft Access databases to MySQL.
高级语言： Perl
项目地址: git://github.com/UrsaDK/mdb2mysql.git
创建时间： 2017-03-17T12:56:15Z
项目社区：https://github.com/UrsaDK/mdb2mysql
开源协议：GNU General Public License v3.0
下载




mdb2mysql logo


stable branch
latest release
donate link

mdb2mysql

A tool to convert Microsoft Access databases into MySQL compatible SQL dump file. This file can then be imported into MySQL just like a standard SQL dump.

Requirements

Synopsis

  1. mdb2mysql [options] <mdb file>
  2.   -c             Create table structure only, no data.
  3.   -d             Add a 'drop table' before each create.
  4.   -e             Use the much faster, extended INSERT syntax.
  5.   -i             Export data inserts only.
  6.   -l             Add locks around insert statements.
  7.   -o <tables>    Omit tables in this comma separated list.
  8.   -r <character> Replace illegal characters with given character.
  9.   -t <tables>    Export only this list of comma separated tables.
  10.   -u             Report unknown Access data type and exit.
  11.   -x             Same as using -d -e -l combined options.
  12.   -M             Convert Access System tables ('MSys') as well.
  13.   -C <type>      Define character set of the transferred data.
  14.   -U <type>      Use the MySQL data type for unknown Access types.
  15.                 Unless given, 'blob' will be used by default.
  16.   -h, --help     This message and exit.
  17.   -V, --version  Output version information and exit.

Changelog

  • v1.1.1

    • Minor documentation updates.
    • Reverted to GNU General Public License v3.

  • v1.1.0

    • Added ability to specify character set for the incoming data in MySQL. This allows for the import of multilingual data from Access databases.

  • v1.0.1

    • All table and column names are now quoted. Thus, fixing a problem when dealing with tables or column names that contain spaces as part of their name.

    • Illegal characters are now stripped out from table/column names by default rather then being replaced by an underscore. This is done to encourage the use of clean table/column names.

    • To avoid errors when trying to move NULL value from Access to MySQL, all columns within MySQL are now allowed to have NULL values. Also, since MDBTools do not export a default value for a column, it is now left to be set by MySQL.

  • v1.0.0