使用.Net应用程序部署MySQL Server + DB [英] Deploy MySQL Server + DB with .Net application

问题描述

HI All，

我们有一个.Net 2.0应用程序，它有一个MySQL后端。我们希望能够在我们安装应用程序并尝试找到最佳解决方案时部署MySQl和数据库。当前设置是将所需的文件复制到本地机器上的文件夹，然后执行NET START命令来安装和启动mysql服务。然后我们使用bat文件将DB的备份恢复到这个新创建的mysql实例。它不是一个理想的解决方案，并试图提出更强大的东西。

We have a .Net 2.0 application which has a MySQL backend. We want to be able to deploy MySQl and the DB when we install the application and im trying to find the best solution. The current setup is to copy the required files to a folder on the local machine and then perform a "NET START" commands to install and start the mysql service. Then we restore a backup of the DB to this newly created mysql instance using bat files. Its not an ideal solution at all and im trying to come up with something more robust.

问题是Vista上的用户权限，以及安装和启动服务的各种小问题。它太脆弱，不可靠，或至少它似乎是这样，当我测试它。这是一个客户/服务器类型设置，所以我们只需要安装一个服务器每个办公室，但我想确保它尽可能麻烦自由，尽可能少的屏幕。

The issues are User rights on Vista, and all sorts of small things around installing and starting the service. Its far too fragile to be reliable or at least it appears that way when i am testing it. This is a Client/Server type setup so we only need to install one Server per office but i want to make sure its as hassle free as possible and with as few screens as possible.

您会如何做？

推荐答案

不知道您在项目中的位置，和小数据库，您可以考虑将其转换为 SQLite 。这不是理想的客户端/服务器操作，但如果它是低容量/事务，它可能工作。

Not sure where you're at in the project, but if it's a simple and small database you might consider converting it to SQLite. It's not ideal for Client/Server operations, but if it's low volume/transactions it might work.

这篇关于使用.Net应用程序部署MySQL Server + DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！