MS SQL versus MySQL 2

[x508]

Hi, can you opinionate on the topic please, would you please share your experiences with MsSQL and MySQL.

Which is better, not money wise, for a remote server that will be connected to from different geographical locations

Thanks in advance

**********************************
May the Code Be With You...
----------
x50-8 (X Fifty Eigt)

 

[TomKane]

The only things I know about MySQL is that it's like SQL Server, can be upgraded to SQL Server, it's free, and that there is some limit to the size the database can grow to.

 

[mmilan]

Most of which is utter tosh - you're thinking of MSDE...

MYSQL is issued under the GPL, for there are fees for licenses for commercial use.

As for handling remote connections, it's not bad - access control through a combination of username and host, and I've never found speed to be an issue with it...

You might seek comment from someone who has undertaken a major project with it though... I'm about to, but haven't done it yet.

mmilan

 

[cyoung]

I have written a large application using MySQL and all I can say is that it is great!

I have a VB front end for the office/intranet use, and by using a combonation of PHP/Flash and Apache, I am able to meet all of my customers needs for internet based reporting

I compared MS-SQL at the time I was planning this application and MySQL was incredibly faster than MS-SQL.

I have yet to find any issues with table sizes, and the built in ability for replication has worked without any problems.

If you are thinking about MySQL, all I can say is to give it a try. You will be pleased with the results.

 

[Michael42]

I am using MySQL side-by-side with Sybase 12 and Oracle 9i. Using Oracle and Sybase only where a customer requests it. I use MySQL on Sun, LINUX and Windows. I\we use it with PHP, Java, PERL, Access and VB.

I like MySQL because for enterprise size - high visibility databases it is several magnitudes easier to install, backup and maintain than the others I work with.

and .... it is fast!

In my environment, as a package deal, it is the DB of choice from both the system admin and application developer's standpoint.

Hope this helps,

Michael42

 

[x508]

OK, kewl, can I ask a few question:

I installed MySQL and now:

1.)Is there an easier way to start and stop the MySQL server than with the command prompt.

2.) IS there a different Database manager that Control Centre, or maybe a better one.

I am having trouble with Control Centre, I cannot create users or change password of existing users, it gives "error while applying grants"

Any help will be greatly appreciated.

P.S. MySQL looks good and I would love to help build the strength of the open source movement

**********************************
May the Code Be With You...
----------
x50-8 (X Fifty Eigt)

 

[Michael42]

x508,

If this is not too obvious. Why don't you post these questions in the MySQL forum here on tech-tips (MySQL AB: MySQL).

It is a very active forum with many very sharp people.

 

[x508]

Excellent, I did not see that.....
cheers

**********************************
May the Code Be With You...
----------
x50-8 (X Fifty Eigt)