CODEWITHSUNDEEP
databaseload-balancingmysql-proxy
JGC
JGC

Reputation: 12997

Is it possible to use mysql proxy for query processing in front of microsoft sql server?

I want to use mysql proxy for processing queries trying to execute. I want to make this process available for all databases like mysql, ms sql server, oracle and ... is it possible to use mysql proxy as base engine and connect these database from that? if no, is it possible to do this by making some little changes to mysql proxy source code?

Upvotes: 2

Views: 789

Answers (2)

JGC
JGC

Reputation: 12997

I found that i have to use other exisiting proxies and change them in order to get what I need

Upvotes: 0

Pekka
Pekka

Reputation: 3644

You could use the standard external stored procedure support in the DBMS, but it would be difficult to map arbitrary queries to something meaningful.

Your are likely to be more successful implementing a lightweight parser as described in MySQL Client/Server Protocol and What communication protocol uses MySQL?.

Your preference that this can be done with 'some little changes' is likely not to be realistic. Expect a major job of the scale of ODBC to implement a generic SQL dialect translator.

Upvotes: 1

Related Questions