将SQL Server数据库转换为MySQL [英] Convert SQL Server database to MySQL

问题描述

我在我的专用服务器上的SQL Server 2008 Express上有一个应用程序数据库。这是不够的我的网络应用程序。

I have an application database on SQL Server 2008 Express on my dedicated server. It's not enough for my web app.

• 是否有任何良好的免费转换工具，可以让我将我目前的SQL Server数据库转换为我的服务器上的MySQL。


• 我的网络应用程序是否能够工作？

推荐答案

问题中没有足够的信息，因为它是真正解决的许多问题，关于网络应用程序是否工作相同。

There isn't enough information in the question, as it stands, to really address the many issues around whether the web app will work the same.

easy 部分将将模式和数据移植到另一个RDBMS。 SQL Server有一套伟大的生成脚本命令来生成 CREATE TABLE 语句。您可以通过SQL Management Studio为您的数据创建 INSERT 语句。

The easy part will be porting the schema and data over to another RDBMS. SQL Server has a great set of Generate Scripts commands to generate CREATE TABLE statements. You'll be able to create INSERT statements as well for your data, all through SQL Management Studio.

挑战来自移动您的应用程序。

The challenge comes when moving your application over.

• 什么是数据访问策略？是所有ADO.NET准备/构建的语句，还是它的存储过程？ LINQ to SQL可能？


• 其中的SQL语句：它们在多大程度上是ANSI标准，以及SQL在TSQL特定关键字上的依赖程度？这里的答案将指向将SQL语句和逻辑移动到新的RDBMS所需的工作量。


• 应用程序依赖于任何SQL Server特有的功能或特性，MySQL不' t有？重写代码以适应MySQL的成本是多少？


• 希望应用程序使用集中式连接字符串。这需要改变，希望它在 web.config 。

• what's the data access strategy? Is it all ADO.NET prepared/built statements, or is it stored procedures? LINQ to SQL perhaps?
• the SQL statements within: to what degree are they ANSI standard, and how reliant is the SQL on TSQL-specific keywords? The answers here will point to the amount of work needed to move the SQL statements and logic to the new RDBMS.
• does the app rely on any SQL Server specific features or features that MySQL doesn't have? What's the cost of rewriting the code to fit into MySQL?
• hopefully the app uses a centralized connection string. That'll need changing, and hopefully it's in the web.config. If it's hardcoded in the data-access code, then it's a game of find+replace.

第二个问题的简短答案是：如果它在数据访问代码中被硬编码，您将无法在新的RDBMS中实现您的数据，并使应用程序工作。必须重新编译才能使用新的数据访问库（ ADO.NET for MySQL ）。

The short answer to the second question is that you will NOT be able to just implement your data in a new RDBMS and have the application work. It'll have to be recompiled to use new data access libraries (ADO.NET for MySQL).

总而言之，它当然可以做同样的工作，但需要的努力不小，100％依赖于代码。

All in all, it can of course be made to work the same, but the effort needed isn't small, and 100% dependent on the code.

这篇关于将SQL Server数据库转换为MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！