Environment configuration of SQL Server data to MySQL database

Attempted to migrate a SQL Server database to a MySQL database in the previous period

Scenario is Perl language read SQL Server for appropriate type conversion data processing after writing to MySQL

Two execution end and one receiving end

The final speed reached is 10 million level of the table about 5 minutes to import the completion of which solves the problem of garbled

A 3G size database takes half an hour

15G 5-hour time consuming

The whole process is as follows:

The first is the configuration of the environment and the installation of Plug-ins.

First, the receiving end.

In a Linux system's machine

installing MySQL

If you have a geo-coordinate field Geo, MySQL needs to use more than 5.5 version of it.

CentOS6.4 installation mysql5.6.14

The execution end is then arranged (it can be installed on another Linux system or installed on a computer with MySQL on it).

Because here we will divide the database table into several to run the data, so if in SQL Server's reading and the speed bottleneck, executes the end machine more, the speed is quicker.

CentOS Install Perl

Perl installation dbdmysql operation MySQL Database

Perl connects SQL Server via UNIXODBC

Finally install the Handlersocket (because Handlersocket has installation steps on the receiver's machine and on the execution side of the machine)

Handlersocket Introduction and Installation and Uninstall