1
First of all I would like to inform you that my knowledge in SQL is of beginner... I have a proprietary MSSQL client application and would like to know if there is any way to get it to access the Mysql database through a linked server or otherwise. The story is this: This proprietary application accesses an MSSQL database server that needs to be exchanged host. I’m studying the possibility of buying an account in one that has only Mysql.
I ran some tests: I migrated the MSSQL database to Mysql via Mysql Workbench; I linked the Mysql server in MSSQL Studio 2012 and managed to do several searches on the Mysql server according to several tutorials available on the internet;
Now the application does not see the database in MSSQL. I was thinking that access to linked servers was transparent to client applications, that the MSSQL server mapped all existing databases and performed the Query s to the correct basis. Is there any way to do what I wish? Either by some configuration or by some application that "emulates" an MSSQL server in a Mysql database?
Thanks in advance for the help
You can make changes to the code of this proprietary application?
– Leonel Sanches da Silva
It’s Gypsy Morrison Mendez, that’s my problem! I can’t change the code because it’s a commercial application. I can only configure the MSSQL server address and database.
– Henrique Lourenconi
How does the application connect to the bases? To work, it would have to be a generic adapter, like an ODBC, otherwise it will not work at all.
– Leonel Sanches da Silva
It connects via SQL Server. The application is all for SQL Server from Microsoft I’m trying to use Mysql databases but in fact I don’t know if it exists as.
– Henrique Lourenconi