SQL Server data migration to MySQL

Just joined the new project just started, a lot of technology has not really stereotypes, the team leader decided to use SQL Server, these days are busy with database design, build tables, write stored procedures, feel pro, but yesterday followed the leader to participate in our seminar on this project, with SQL The server's plan was rejected directly, not because of performance or anything, just because---money. When talking with customers was cut off millions of, the director said a set of SQL a hundred thousand of, we this project to build more than 10 servers, this is really out of cash. (Oracle not to mention, this is really expensive) so we can only be forced to use open source MySQL, this does not collect money.

So before the SQL Server data will be migrated to this side, before MySQL contact, check the information and practice the next feeling and SQL use almost, also no longer detailed introduction, here is mainly about how the data migrated, and the corresponding stored procedures how to write, because I temporarily did not find the SQL can be Server stored procedures directly migrated to MySQL method, may be knowledge is not enough, want to have to know the reader, in the bottom of the message, thank you, a lot of exchanges, and common progress.

We use the MySQL visual tool---Navicat, we can download Baidu.

And then as the operation

Here, the next step may be to show the error message of the connection failure, which probably our MySQL service is not turned on, or the user is not logged in. We only need to open the MySQL service (net start MySQL) in the MySQL command window and log in to MySQL (mysql–uroot-p) with the appropriate user.

The next step is to follow the prompts until the completion, the latter process is relatively simple, no longer repeat.

Feelings: usually do not feel, in fact, we use the software, and even the operating system is a lot of cases are cracked, that is, no money, but in the real software development process really used to find the Chinese software industry and foreign software industry gaps exist, it is difficult to imagine that we really live every system in the database, Operating systems and so on to Microsoft, Oracle and other companies valuable royalties. And the Chinese software way out where, I caishuxueqian dare not say more, but I believe that each of our progress, every communication, every share is a small step can be seemingly insignificant, can also be a storm can form the ' butterfly effect '.

SQL Server data migration to MySQL