Mysql access via MSSQL client

Asked

Viewed 114 times

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

mysql sql-server
  • 1

    You can make changes to the code of this proprietary application?

  • 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.

  • 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.

  • 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.

No answers

Browser other questions tagged mysql sql-server

You are not signed in. Login or sign up in order to post.