MSSQL to MySQL API conversion layer

I'm looking for a program that can emulate, impersonate a Microsoft SQL server and convert and write the queries to a MySQL database. Thus allowing me to configure client applications developed for SQL Server database systems only, to connect to the emulator and thus writing and reading the MySQL based records.

Any he开发者_JAVA技巧lp will be highly appreciated.

In all but entirely trivial cases this is not at all easy, and in general is not practical. The only thing that will impersonate a Microsoft SQL Server is SQL Server. Some of the facilities of MSSQL are not available on MySQL (and vice versa).

If you can't redo the client application to use database abstraction, your best bet is to install SQL Server.

An actual Microsoft SQL Server will impersonate it self perfectly. Just think of this MSSQL Server as your "intermediate layer", and then write another app that moves or updates the data you need into or from a separate MySQL database.

That's why there is no purpose to such an expensive proxy layer, because, you can just use the actual DB Engine required by the app, and then connect to that Engine from another app to do whatever you need to do.

Why is it so expensive? Think of the extent of the different SQL dialects, the communication protocols, and the continuous updates that they both receive by huge development teams. The developers of MSSQL and MySQL are working every day to make such a proxy server harder to implement.

I'm not sure what the licencing rules would be, or the legal implications - but how about you write one? It's likely that you aren't the only person who would want one, but I'm not aware that one exists.

I suspect MS have put a considerable investment into making features that other database engines would struggle to implement (intentionally so) so for things beyond the vanilla, it would probably be quite tricky.

That said, since there express versions of SQL Server available (size limited, but fine for small databases), Any reason you can't use that?