DB Server of Choice

[mrNickname]

I'm new to setting up this pangya server and from what i read the server only support MSSQL 2005, i just wonder if MSSQL 2008 and perhaps even MySQL can work with it? I'm much familiar with MySQL then MSSQL..

Thanks

[MentaL]

[Tsukasa]

Microsoft SQL Server 2008 works beautifully with the Pangya server.

I doubt that MySQL will suffice, though - the database uses a lot of stored procedures that make use of SQL Server specific functions.

You could give it a try and report back, though. It's a nice experiment. :)

[mrNickname]

Hey thanks for the reply, i just tried to submit the Server SQL files into MySQL server came up with error, i guess the SQL files here are use for MSSQL only.

I'll first get the game to run with MSSQL 2008 and will find a solution if i can convert those SQL files to MySQL compatible then try it from there.

Btw, do you know in which order should i boot the server executable? o_O;

Auth Server
Bind Server
Login Server
Msg Server
Py_Game Server
Ranking Server

[Tsukasa]

The order doesn't matter.

If you don't like to see E_AUTH errors (which just indicate the auth server cannot be contacted) during your bootup, try this order:

- Auth
- Login
- Bind
- Msg
- Game
- (Rank - which I don't start anyway)

But as I said... it doesn't really matter.

[mrNickname]

Yeah i do hate the error msgs very much lol, i'll keep that in mind thanks and..err i think i used the wrong version of the MSSQL. =.=

Coz i just went on a tutorial that how to use the MSSQL and there are stuffs missing. This is a nice tutorial site for all the MSSQL newbs: SQL Server - Lesson 03: Starting Microsoft SQL Server

I downloaded the 'Database only' in which i think need 'Database with
Management Tools' SQL Server 2008 R2 Express - Installation Options

FML~

[chiosin2]

i work with SQL '05 and it works just fine. although i should make the switch to 2008 soon just so i can understand more of this thing. I don't know much about sql, but i do my best to read about it and understand it first before trying anything else.

my point is, 2005 express works fine with this. just needs a little tweaking to get everything in order ^^

[mrNickname]

My MSSQL download stalled on my side due to ISP issue, but i should able to get the program by tomorrow. At the mean time i tried to submit the .sql dumps to MSSQL but failed due to script error reported using Navicat 9 which i have to blame the .sql files are not being dumped properly or Navicat being picky.

Just in advance i'd like to ask if any of you can upload the full sql dump from your SQL because i'm also confused with the errors and fixes that i'm not familiar about. Thanks in advance ^^;

After i get the data into MSSQL this is what i'll try as well; using Navicat to extract data from MSSQL and save as MySQL dump. From there submit the dump to MySQL Server, adjust ports and configs with Pangya Server, it might work.. o.o