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

[Chester Wisniewski]

Michael Lueck wrote:
> 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
>
> _______________________________________________
> Members mailing list
> Members at kalamazoolinux.org
> 
>   
Not to crash the party, but if you are using MySQL for a commercial use, 
it still requires a license. Its cheaper, but not free....

Chet