First of all I would like to inform you that my knowledge in SQL is beginner ... I have a proprietary MSSQL client application and would like to know if there is any way to get it to the MySQL database through a linked server or another way. The story is as follows: This proprietary application accesses an MSSQL database server that needs to be changed host. I am studying the possibility of buying an account in one that has only MySQL.
I ran some tests: I migrated the database from MSSQL to MySQL through the MySQL Workbench; Linkei the MySQL server in MSSQL Studio 2012 and I did several searches on the MySQL server according to various 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 queries to the correct database. Is there any way to do this that I desire? Is it by some configuration or some application that "emulates" an MSSQL server in a MySQL database?
Thanks in advance for the help