I've created a multiple user application in WinForm and it have a database on the server which is on the other computer. So far, i set up the server database (MySql) manually and create each tables in the database manually as well. I was wondering is there a way to create (maybe an exe file) to automate the entire process?

I've did some searching on the internet but most of the answer i get are the configuration of the database which i've go through it when i did the manual set up. I developed the application and the database separately so what is related to the database in my application are the connection string only. i did managed to publish the application and now i need to find a way to publish my server database.

CodePudding user response：

With mysql you cannot automate the install of the mysql software, unless you have a paid for enterprise licence or you release your software as open source under GPL.

To automate mysql installation, you can use mysql installer console.

What you can definitely automate is the deployment of your mysql data structure and the configuration of the mysql instance.

The former requires an sql script that creates the database and all other database objects (tables, indedes, views, users, etc) that you can execute as part of an install process. The latter requires overwriting or adding your settings to my.cnf / my.ini configuration files.