部署MySQL服务器+数据库与.NET应用程序 [英] Deploy MySQL Server + DB with .Net application

问题描述

大家好，

我们有一个.net 2.0应用程序，它有一个MySQL后端。我们希望能够部署MySQL和数据库，当我们安装应用程序和IM试图找到最佳的解决方案。目前的设置是必要的文件复制到文件夹在本地计算机上，然后执行NET START命令来安装并启动mysql服务。然后，我们的数据库的备份恢复到使用批处理文件这个新创建MySQL实例。它不是在所有和IM试图拿出一些更强大的的理想解决方案。

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.

这篇关于部署MySQL服务器+数据库与.NET应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！