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

问题描述

HI全部，

我们有一个具有MySQL后端的.Net 2.0应用程序。当我们安装应用程序并尝试找到最佳解决方案时，我们希望能够部署MySQl和DB。当前设置是将所需文件复制到本地机器上的文件夹，然后执行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屋！