How to connect remote database MySQL - OpenNOS

08/13/2019 13:29 Pokatny_Handlarz#1
Hello, I have the following question if it is possible, if so, what to connect this project: [Only registered and activated users can see links. Click Here To Register...]

to the remote MySQL database I have to specify:
user
password
base name
08/13/2019 13:57 Blowa#2
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)
08/13/2019 14:26 Pokatny_Handlarz#3
in that case, I will probably use the local database or will it work?
[Only registered and activated users can see links. Click Here To Register...]
08/13/2019 14:31 Blowa#4
Quote:
Originally Posted by Pokatny_Handlarz View Post
in that case, I will probably use the local database or will it work?
[Only registered and activated users can see links. Click Here To Register...]
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)
08/13/2019 14:36 Pokatny_Handlarz#5
I would love to download this type of database, I need to buy a license or create an account
08/13/2019 14:48 Blowa#6
Quote:
Originally Posted by Pokatny_Handlarz View Post
I would love to download this type of database, I need to buy a license or create an account
[Only registered and activated users can see links. Click Here To Register...]
(taken from : [Only registered and activated users can see links. Click Here To Register...]

Enjoy, the developer edition should fit enough with your needs :)
08/13/2019 17:23 erixor#7
Why would you use MySql in the 1st place ?
08/13/2019 19:22 Pokatny_Handlarz#8
You may have SQL server version 2019 because I have this version on Visual Studio Community and I can't install
08/20/2019 21:18 Nagisa Shiota#9
Quote:
Originally Posted by Pokatny_Handlarz View Post
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?
10/22/2019 23:16 Pokatny_Handlarz#10
Windows 10