MySQL Forums
Forum List  »  Connector/ODBC

Re: Syntax to access the remote database/server
Posted by: Peter Brawley
Date: June 24, 2020 09:41AM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: Syntax to access the remote database/server
June 24, 2020 09:41AM


Sorry, only registered users may post in this forum.

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.