且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将MS SQL数据库表复制到MySQL数据库

更新时间:2023-02-02 21:01:25

尝试MySQL迁移工具包:

http://downloads.mysql.com/archives.php?p=mysql-migration-toolkit [ ^ ]

同时验证移动原因请阅读以下文章:

http://dev.mysql.com/tech -resources / articles / move_from_microsoft_SQL_Server.html [ ^ ]

检查你的连接字符串:

Try MySQL migration Tool Kit:
http://downloads.mysql.com/archives.php?p=mysql-migration-toolkit[^]
Also validate why to move frpm the article below:
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html[^]
Check your connection string:
<add name="connstring" connectionString="server=192.168.1.2;User Id=root;Persist Security Info=True;database=test;password=password" providerName="MySql.Data.MySqlClient"/>



然后您的代码应如下所示:


Then your code should look like:

using (MySqlConnection dbConn = new MySqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString))
{
    // Database work done here
}