Re: Syntax to access the remote database/server
OpenQuery() is SQL Server syntax, to use it you'd need to have installed MySQL Connector/ODBC and Microsoft SQL Server, then created a linked server connection to an insalled MySQL server with Connector/ODBC.
You can migrate dbs and their contents with the WB Migration Wizard, otherwise AFAIK WB can work with one server at a time. To move data from one server to another, you need to connect to one server, retrieve data into a buffer or file, then connect to the other MySQL server and import from the file or buff.er
Subject
Written By
Posted
Re: Syntax to access the remote database/server
June 24, 2020 09:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.