How to connect remote database MySQL - OpenNOS

[Pokatny_Handlarz]

Hello, I have the following question if it is possible, if so, what to connect this project:

to the remote MySQL database I have to specify:
user
password
base name

[Blowa]

You will have to regenerate the migrations & also to modify the connection string used by EF to connect to your DB (MySQL)

Another thing is that you will probably need to use MySQL providers for EntityFramework (if you don't know how it works, a lot of documentation should be available through stackoverflow)

[Pokatny_Handlarz]

in that case, I will probably use the local database or will it work?

[Blowa]

Originally Posted by Pokatny_Handlarz

in that case, I will probably use the local database or will it work?

Whether you use MySQL locally or remotely, you'll need to change OpenNos code simply because all opennos based source uses MSSQL (except Polygon that uses PostgreSQL but is not public)

You should use MSSQL, installing or through a docker (I'm not recommending to use docker for production usage outside Linux, Windows & MacOS are not as performant with Docker as linux because it runs on a VM)

[Pokatny_Handlarz]

I would love to download this type of database, I need to buy a license or create an account

[Blowa]

Originally Posted by Pokatny_Handlarz

I would love to download this type of database, I need to buy a license or create an account

(taken from :

Enjoy, the developer edition should fit enough with your needs

[erixor]

Why would you use MySql in the 1st place ?

[Pokatny_Handlarz]

You may have SQL server version 2019 because I have this version on Visual Studio Community and I can't install

[Nagisa Shiota]

Originally Posted by Pokatny_Handlarz

You may have SQL server version 2019 because I have this version on Visual Studio Community and I can't install

Who is your windows version?

[Pokatny_Handlarz]

Windows 10