Need help convincing customer

[romh]

Hi, I have a customer that I'm writing a database for. They currently have a database written in sql server 2000. They asked me to make them a seperate program and I've designed it with Mysql. Mysql is my favorite choice.
I was thinking about simply rewriting the tables over to sql server, and changing from odbc to native sqlserver calls.
I wrote the whole front end with asp.net. But now, I want to tell my customer to install mysql alongside sqlserver 2000. There aren't too many tables, only about 12.
I was reading that sqlserver uses port# 1443 instead of mysql's 3306, so it shoudn't be a problem.
The customer has a very slight idea what SQL server is, but I am sure has never heard of Mysql. He just wants the program to do what its intended to do.
Can I just show him what the mysql.com website says about how Nasa, Google etc.. and over 10 million copies were installed last year. And how its faster than SQL server for pulling records etc.... The database will consist of a combination of inserting records but mosty selecting them for viewing. I've handled Referential integrity though code.

Anyway, thanks

 

[ericbrunson]

As much as I hate Microsoft, I'd actually choose to avoid having two different databases installed, just for simplicity of configuration. Unless you can port their other tables over to MySQL, I'd just use the SQL server. Why can't you use the ODBC driver with SQL Server? That was the promise of ODBC, wasn't it?

 

[sleipnir214]

I agree with ericbrunson. Having two parallel database systems unnecessarily complicates things. If the SQL Server is what's already there, I recommend that you use that for your application.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[ericbrunson]

Though, to answer the original question, there is not technical reason why the two databases can't be installed on the same machine.

 

[romh]

I can definately use ODBC to call msqlserver. I don;t think porting over 12 tables to MS SQL Server will be very difficult or time consuming. I just like mysql more. And since I have designed the beta versin in mysql, I though it would be better to keep using it.
Would I look like a novice to an outside person if they noticed that I recommended the idea of using mysql while they had MS SQL server 2000 in use?

 

[ericbrunson]

Only to the uninitiated. MySQL used to have it's issues, but even coming from an Oracle background I feel that anyone that doesn't respect it as a valid platform is just displaying their own ignorance.

Don't forget that the usage agreement for MySQL requires purchase of a license for commercial use.

 

[romh]

Thanks. Good point about the license agreement.