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

问题描述

大家好，

我们有一个 .Net 2.0 应用程序，它有一个 MySQL 后端.我们希望能够在安装应用程序时部署 MySQl 和数据库，并试图找到最佳解决方案.当前的设置是将所需文件复制到本地机器上的一个文件夹中，然后执行NET START"命令来安装和启动 mysql 服务.然后我们使用 bat 文件将数据库的备份恢复到这个新创建的 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屋！