如何为我的Exe文件安装数据库.. [英] How Do I Install Database For My Exe File..

问题描述

我在后端mySql中用C＃（visual studio）创建一个s / w。我创建了我在visual studio中创建的exe文件。

所以我的问题是 -



a）如果我在其他计算机上安装exe文件然后我必须在那台电脑上安装Mysql workbrench？



b）如果是的话我该如何安装呢？

解决方案

不 - 或者如果可以的话，你做错了什么。

MySql是一个基于服务器的系统，所以你真的不应该安装它 - 用户应该，或者你应该使用现有的实例。



有几个原因：

1）他们可能已经在网络上安装了MySQL。如果是这样，那么他们可能会想要使用该版本。

2）如果他们确实安装了MySQL并且您开始扩散服务器实例，那么您将会惹恼数据库管理员。 。

3）单个站点安装比用户控制下的许多分散版本更有可能被备份。

4）MySql非常复杂普通用户安装和管理 - 这不是一个好主意！

5）它将破坏使用基于服务器的数据库而不是SqlCE或SQLite的主要优势 - 多用户访问。如果每个人都安装了自己的副本，那么您将拥有数据库的多个副本，每个副本由一个人使用。这会引起一些混乱，并且（取决于你如何编写原始数据库）可能需要花费相当大的努力才能在问题实现时组合成单个实例。

你可以检查是否有任何问题MySQL服务器安装在目标计算机上。

如果服务器不存在，则将其安装在C＃应用程序中。



对于架构/数据库结构安装，你可以使用：

MySqlBackup.NET - 用于C＃的MySQL备份解决方案， VB.NET，ASP.NET [ ^

i create a s/w , by C# (visual studio) , at backend mySql. i create exe file which i create in visual studio.
so my Question is-

a)if i install the exe file in other computer then i have to install Mysql workbrench on that computer ?

b)if yes then how can i install it?

解决方案

No - or if you can, you have done something very wrong.
MySql is a server based system, so you really shouldn't install it at all - the user should, or you should use an existing instance.

There are a couple of reasons:
1) They may already have MySQL installed on the network. If so, then they will presumably want to use that version.
2) If they do have MySQL installed and you start proliferating server instances, you are going to annoy the heck out of the database administrator...
3) A single site installation is a lot more likely to be backed up than a number of scattered version under user control.
4) MySql is quite complex for a "normal" user to install and administer - it is not a good idea!
5) It will destroy the primary advantage of using a server based database over SqlCE or SQLite - multiuser access. If everyone installs their own copy, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.

you can check if any MySQL server installed in the target computer.
If the server if not exists, then install it in your C# application.

For schema/database structure installation, you can use:
MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET[^]

这篇关于如何为我的Exe文件安装数据库..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！