SQL Server 2008

drakelord · #1 04-27-2009, 06:45 PM

Not sure if the queries that world/zone server use are compatible with SQL Server either. You might end up having to make changes and recompile the code. And it would be quite a few changes.

nosfentora · #2 04-28-2009, 04:12 PM

yea the queries are a little different, which is why exporting via navicat (to a csv format) and then importing with 2008 choosing a csv format should work.

EvoZak · #3 04-28-2009, 11:56 PM

I think drake's point is that the emulator doesn't really have a data layer per se. Rather, a bunch of embedded sql queries throughout the code.

Not that there's anything wrong with that. Just not easy to switch back ends.

nosfentora · #4 04-29-2009, 09:01 AM

Duh - if I could actually read.... =)

drakelord · #5 04-29-2009, 09:35 AM

What EvoZak said. And the reason changing it would be hard, is that there isn't really a "Query builder" for all of the queries in the program. A lot of them are literally the queries that they want thrown in, like, "INSERT INTO suchandushch WHERE blabla=y". So you'd have to hunt down every one of these queries and match it to the sql server format. A daunting task.

Yeormom · #6 05-13-2009, 11:59 PM

My server uses Microsoft SQL 2008. So yeah, it can be done. My crude benchmarks showed a 19% increase in performance but I've still got database related bugs to work out. If you hit Google, you can find some replication tools that can aid you in keeping one database instance replicated on a MySQL database and SQL server database in real time but that kills the performance factor.

blackdragonsdg · #7 05-14-2009, 11:25 PM

Quote:

Originally Posted by Yeormom

My server uses Microsoft SQL 2008. So yeah, it can be done. My crude benchmarks showed a 19% increase in performance but I've still got database related bugs to work out. If you hit Google, you can find some replication tools that can aid you in keeping one database instance replicated on a MySQL database and SQL server database in real time but that kills the performance factor.

It is nice to know that it can be done. I am working on changing over as I have time but I think it is going to be a slow process. Been working with SQL Server 08 more than anything just trying to learn all the ins and outs as I go, this is a trial by fire for me.
As for replicating the database in real time, well, that is not really an issue for me as I use a mini login and the game server is only up and running when me and my friends wanna play.