[MXS-1] MaxScale filter to real Microsoft SQL Server syntax Created: 2015-03-02  Updated: 2016-10-10  Resolved: 2016-10-10

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Unassigned
Resolution: Won't Do Votes: 4
Labels: gsoc15, gsoc16


 Description   

Develop a MaxScale filter that will translate SQL Server syntax to MariaDB syntax. Develop a SQL Server client protocol plugin.



 Comments   
Comment by Wepngong Ngeh Benaiah [ 2016-03-03 ]

Hello @Sergei Golubchik

I am a 4^th^ year BEng Student in Computer Engineering at the University of Buea. I am specialized in Software development and have been using MariaDb and Java since 2 years ago. I have proficient skills in C, Java and PHP and will like to work on this issue as a way of contributing to MariaDb by means of GSoc2016.
I will appreciate any pointers on this issue and how I can proceed to draft a proposal for it.
Kind regards!
Wepngong Ngeh Benaiah

Comment by markus makela [ 2016-03-16 ]

This filter should only do SQL level translation, not network level. That should be handled by a separate protocol module.

With this filter, one would connect using MySQL wire protocol but would still talk in MS SQL. The expected results would be returned according to the MySQL protocol.

Comment by Wepngong Ngeh Benaiah [ 2016-03-16 ]

@markus makela
From what you explain, this means that an existing MS SQL application for example will not change its code but will however just change its connection string to suite that of MySQL and the filter will handle everything else. Am I correct?

Comment by markus makela [ 2016-03-17 ]

Using a MariaDB connector and the filter this task describes would allow MS SQL applications to talk to MariaDB databases. So the filter only translates on the language level.

Comment by Bo [ 2016-03-20 ]

I am a student from Clemson univerisity. What does that mean "using filter to conver Mysql SQL to MS SQL " ?
Could I write a C++ program as MaxScale filter and translate the MySql -> MS Sql ? If so, I think it is just as same as a compiler front-end problem.

Generated at Thu Feb 08 03:56:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.