更新时间: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
}