如何将vb.net数据表或数据库转换或更改为MySQL数据库 [英] How to convert or change vb.net Datatable or database to MySQL database

问题描述

大家好，

我当前正在尝试将vb.net数据表或数据库转换或更改为MySQL数据库.但是我不知道该怎么办.

I am currently trying to convert or change vb.net datatable or database to MySQL database. But I don't know how to do.

请帮助我

推荐答案

ppkkyaw，

>>我目前正在尝试将vb.net数据表或数据库转换或更改为MySQL数据库.但是我不知道该怎么办.

>> I am currently trying to convert or change vb.net datatable or database to MySQL database. But I don't know how to do.

根据您的描述，我不明白数据库.而DataTable就像vb.net中的对象一样.可能是来自SQL Server的DataTable.如果要转换 在SQL Server数据库中的datatable中，您可能会注意到SQL Server和MySQL中的表结构是否相同.将数据库从MS SQL迁移到MySQL服务器时，通常还需要根据MySQL语法转换MS SQL查询. MS SQL和MySQL中SQL查询的语法相似但不相同.

According to your description, I don’t understand what is the database. And the DataTable just as object in vb.net. May be the DataTable from SQL Server. If you want to convert datatable which in SQL Server database, you could note whether the table structure in SQL Server and MySQL are the same. When migrating databases from MS SQL to MySQL server it is often necessary to translate MS SQL queries according to MySQL syntax as well. Syntax of SQL queries in MS SQL and MySQL are similar but not identical.

此链接与 如何将Microsoft SQL Server迁移到MySQL Databse .

This link is about how to migrate Microsoft SQL Server to MySQL Databse.

希望对您有帮助.

Hope it’s helpful to you.

最好的问候， span>

Best Regards,

Neda Zhang

Neda Zhang

这篇关于如何将vb.net数据表或数据库转换或更改为MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！