About MSSQL 2005 <-> 2012 (SP1)

[Worf]

Hey everyone,

I've made this thread after answering a help thread about this.

In all the guides to make a FlyFF server there is reference to MSSQL 2005. It will do the job but, there is much better version out nowadays.

I will name the reasons why you can better take MSSQL 2012 (SP1).
Since the 2012 release, Microsoft has changed it's limit policy for the Express versions of MSSQL. In all versions BEFORE 2012 there was a connection limit to the server of 500. Thus making it impossible to have much characters connecting at the same time.
All 2012 versions have a new policy, instead of 500 connections, it now has a max of 1GB of active memory. Since the flyff database is lightweight (it uses approx 38mb clean) there is no chance, even with thousands of players to actively reach 1GB of memory usage from the MSSQL engine. This is a very good advantage since it allows us to run professional servers on the express version.

Besides the better express limitation it's more efficient and secure. It functions better (and is made for) windows 7/8 server 2008 and up, than the older 2005 version.

So to conclude, if you see 1 of these guides:
- Dell Honne's Server setup
- Thrinaria's Server setup

Than follow the tutorial, but instead of downloading and installing MSSQL 2005, use 2012 SP1 instead.

You can download it here:
-

You must be registered to see links

Please choose your preffered Language and than choose 1 of the following files:
- SQLEXPRADV_x86_ENU.exe
- SQLEXPRADV_x64_ENU.exe

NOTE: Please choose the version wich suit your Operating Systems architecture. This is either 32bit (x86) or 64bit. You can check it in the System Info.

Enjoy your server.

Worf

 

[Mootie]

Since the 2012 release, Microsoft has changed it's limit policy for the Express versions of MSSQL. In all versions BEFORE 2012 there was a connection limit to the server of 500. Thus making it impossible to have much characters connecting at the same time.

What makes you believe this is a limitation? The trans server makes less than 100 connections to MSSQL even if 1000 players are online at once.

All 2012 versions have a new policy, instead of 500 connections, it now has a max of 1GB of active memory. Since the flyff database is lightweight (it uses approx 38mb clean) there is no chance, even with thousands of players to actively reach 1GB of memory usage from the MSSQL engine. This is a very good advantage since it allows us to run professional servers on the express version.

I'd much rather have unlimited RAM usage than unlimited active connections. In a server with 300+ players, 1GB of RAM for SQL Server isn't going to cut it.

Besides the better express limitation it's more efficient and secure. It functions better (and is made for) windows 7/8 server 2008 and up, than the older 2005 version.

Just because it's new doesn't mean its more efficient or secure. It does have more advanced features, but without using them, it's no different than MSSQL 2000 even.


In addition, the flyff databse wont run on SQL Server 2012 without modifications to various stored procedures since SQL Server 2012 dropped support for the *= (LEFT OUTER JOIN) syntax. It isn't too hard, but still... Have you even tried using this yourself before suggesting it to others?

 

[pedroalves]

It would be more usefull if you had posted a tutorial to convert our MSSQL2005 Databases to MSSQL2012 (SP1).

 

[Worf]

It would be more usefull if you had posted a tutorial to convert our MSSQL2005 Databases to MSSQL2012 (SP1).

There is no need for conversion, the 2005 database will work fine on 2012. The difference in 2005 -> 2012 is, that when you restore the backup, in 2012 you need to specify the name of the database yourself.

 

[pedroalves]

There is no need for conversion, the 2005 database will work fine on 2012. The difference in 2005 -> 2012 is, that when you restore the backup, in 2012 you need to specify the name of the database yourself.

Oh! The problem could be the database, so!
Thank you alot Worf =)