SQL Server 2000?

IANumtin · #1 05-23-2003, 02:41 AM

I've searched through 32 pages of forums from a search string and haven't found anything relating to this but here it goes:

Is it possible to use SQL Server 2000 instead of MySQL? If so, are there changes I would need to make on some of the files?

I thought I might ask since I do have the capability of running it, I thought it might be a little more stable than MySQL. Any thoughts?

Trumpcard · #2 05-23-2003, 03:27 AM

What makes you think mySql is unstable is my 1st thought?

It's not... Its actually very stable, and alot more securce than SQL Server.

But, to make it work, you would need to change all the mysql API code inside of EQEMU to use a generic ODBC API of some sort.

IANumtin · #3 05-23-2003, 05:57 AM

Was just a thought. Didn't mean to say MySQL was unstable, sorry about that. Just thought SQL Server might be able to do more. Seems like it would be more of a pain to change everything than to just stick with MySQL.

Trumpcard · #4 05-23-2003, 06:23 AM

Its no problem.. I've thought the same time several times that it would be good to convert EQEMU to use any arbitrary database system, ORACLE, DB2, Postgres, etc, but realized after awhile, why bother?

mysql is simple, efficient, and free... It takes minutes to set up a complete database system, and it's easy to maintain. Anyone that is going to have trouble figuring out how to set up a database is going to have ALOT more trouble with one of the other db's out there, so makes sense to just stick to mysql.

ORACLE would be sweet though...

fx · #5 05-27-2003, 05:43 AM

Quote:

What makes you think mySql is unstable is my 1st thought?

Perhaps the mysql engine itself is stable, but the front end tool I use to work with it certainly is: mysql-front. Which tool are you using? I would certainly like to get ahold of a stable front end for working with the DB.

Front crashes on literally every other statement I try to execute. It even crashes on statements I execute that have simple syntax errors. It's routine for me now: copy statement to clipboard, exec statement, see crash, start back up, paste statement, re-exec, no crash.

Trumpcard · #6 05-27-2003, 06:12 AM

I use direct sql to manipulate the database when I need to make changes, I don't use an admin tool.. Try phpmysql tied to an apache webserver. It works pretty well for most things.

adinobro · #7 05-29-2003, 08:47 PM

I'd have to agree with Trumpcard.

Most of the free front end tend to suck. There are a few ones that you pay for that are ok but PHPmyAdmin is just so go it makes all the other programs look even worse in comparison.

The only problem is that you have to install php to use it. Even if you don't want to use Apache you can use it with IIS *SHUDER* lots of howto online and you can even use one of the PHP+MySQL+PHPMyAdmin+Apache combos around

.

Last time I look there were about three of them on source forge.