I have a database in mySQL and I wanted to replicate it to SQL Server so I can make queries in a better way (i believe sql server is much more user-friendly to make queries). I've been trying to make a linked server to this mysql database and when I got it (at least it appears in my "Linked Servers" list with all the catalogs and tables), I can't run queries directly...
I'm posting a picture of the linked server i built. When I try to query directly into the tables it doesn't work...
SELECT * FROM hitme.dbhitsystem.tbldatabases;
But when I use openquery it does work:
SELECT * FROM openquery(hitme,'SELECT * FROM dbhitsystem.tbldatabases')
Is there anyway I could make queries directly, using intellisense??
Thanks in advance