MSSQL to MySQL API conversion layer

views:

answers:

MSSQL to MySQL API conversion layer

Hi,

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

Any help will be highly appreciated.

+2 A:

In all but entirely trivial cases this is not at all easy, and in general is not practical. The only thing that will impersonate an MSSQL server is MSSQL, 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 MSSQL.

Woody 2010-07-20 14:38:56

Thanks,Several custom applications were developed by a third party for our company. The host IP, instance, database etc. configurations were all hard coded, YES?. Now I'm unable (unless I keep the hostname and setup exactly the same) to retire the DB host and migrate all the databases to the new host. Maybe I could use some sort of editor, perhaps a Hex editor to amend the applications, don't know how to do this yet!

Cor Cronje 2010-07-29 06:30:00

Hardcoded DB ip? That is awful, did you pay them?! Hardcoded database type is not unusual, but address is.You could put a proxy to redirect the IP, but you wont be able to change the type. I wouldn't recomend using a hex editor on an application that is used in your company (not that I haven't done it). Best option would be to get back to the company who sold you the applications and ask for them to fix the hardcode, which I would consider a fault.

Woody 2010-07-29 09:05:18

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?

Ragster 2010-07-20 14:40:20

Cor Cronje 2010-07-29 06:46:17

Gosh. Ok, Given that background, I have to say, your best long-term option is almost definately, re-write the application. Yes, it will cost, and you'll have to deal with the loss of the original investment, but not having the flexibility you need, or the proper ownership of yoru code will cost you again and again. The sooner you pay the exit fee and get it done properly, the better.For your own benefit, I really would advise you to get the system re-done.

Ragster 2010-07-29 15:55:57

ansaurus

tags:

views:

answers:

MSSQL to MySQL API conversion layer

related questions