MYSQL和VB.NET EXE设置指南最后阶段 [英] MYSQL and VB.NET EXE Setup guide final phase

问题描述

在我继续提问之前，让我们为您提供项目的详细信息：



我在VB.NET中开发库存+会计软件并使用MYSQL作为数据库！现在我的问题如下：



1.如何制作一个包含MYSQL服务器安装设置的安装包



2.当用户正在运行设置时，应该自动创建数据库表，如何使其成为可能！



我的项目非常紧急在最后阶段，任何有关这方面的帮助将是一个大忙！



SHOUTING删除 - OriginalGriff [/ edit]

Before i proceed with my question, lets give you the detail about the project:

Am developing on inventory + accounting software in VB.NET and using MYSQL as database! now my question as below:

1.How to make a single setup package which include MYSQL server installation setup within it

2.while user is running the setup, database table should be created automatically, how to make it possible!

Its really urgent as my project is in final phase and any help regarding this would be a big favor!

[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案

1）不要。这是一个简单的答案。

您不应该在安装中包含任何数据库服务器系统。有几个原因：

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

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

1.3）数据库服务器的单站点安装比用户控制下的许多分散版本更有可能被备份。

1.4）服务器对于普通用户来说安装和管理是非常复杂的 - 这不是一个好主意！

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



2）连接到MySQL实例，并检查表是否存在。如果确实如此，那就更不用说了。如果没有，请发出创建它的命令 - 您可以使用其中一个MySql管理工具从现有表创建脚本，并在其中存储设置随后引用的文件。

1) Don't. That's the simple answer.
You should not include any database Server system in your installation. There are a couple of reasons:
1.1) They may already have a server installed on the network. If so, then they will presumably want to use that version.
1.2) If they do have a server installed and you start proliferating instances, you are going to annoy the heck out of the database administrator...
1.3) A single site installation of a database server is a lot more likely to be backed up than a number of scattered version under user control.
1.4) A server is quite complex for a "normal" user to install and administer - it is not a good idea!
1.5) It will destroy the primary advantage of using a SQL server over SqlCE or SQLite - multiuser access. If everyone installs their own copy of the server, 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.

2) Connect to the MySQL instance, and check if the table exists. If it does, nothing more to do. If it doesn't, issue a command that creates it - you can use one of the MySql management tools to create the script from your existing table and store in it a file which the setup then references.

这篇关于MYSQL和VB.NET EXE设置指南最后阶段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！