[KLUG Members] MySQL acting as if it is SQL Server

[Michael Lueck]

On 03 Jul 2006 12:55:11 -0400, bill wrote:

>Haven't done it myself, we've always re-written the app.

Yes well that would significantly increase the investment and risk for
tinkering wiht a bit of OSS/FS then, would it not.

>But if I had
>to do it I'd look into ODBC.

OK, so you are thinking that the SQL Server client piece of software has
configurable enough settings in it to get it to work in ODBC mode, and just
happen to point its DSN at the MySQL box then, and see if things just magically
work.

My preference would be to do this in such a way that the client machines still
run the software as-was (other than server name, DSN type stuff) and the server
becomes a Linux / MySQL box. There are tons of these such apps out there. Once
they were all DOS based, PC database files, bla bla bla... now PC based
databases are bad evil awful, so all of these types of developers just use the
new defacto standard - SQL Server... "easier than thinking" ja know. That is a
lot of licen$e just because PC database files are no longer vogue... seems to
me MySQL could do it just fine. Further seems to me, a good business for MySQL
if they could come up with a way to hot wire MySQL servers in where SQL Server
was spec'ed.

At least the new M$ filesystem got trashed from Vista... so that is a bit of 
buffer space holding proprietary back from doing weird things that Linux /
OSS/FS would have a harder time emulating. Get MySQL working as a drop in
replacement for SQL Server requiring no code changes, and you can bet that
filesystem would be back to tangle developers into a M$ centric platform.

Anyway, 'tis a side thought project. We do like options in this country... so
why would the only answer to "I need a database" be "SQL Server?" ;-)

Happy 4th All,
Michael