May 18, 2021 at 2:07 pm
Hi everyone.
Very new to the MySQL environment..
Is there a MySQL equivalent to a MS-SQL linked server?
Linking 2 MySQL servers to each other and avoid moving data between them via txt/csv/sql dump files.
Thanx..
May 18, 2021 at 5:24 pm
Not a direct equivalent but to access tables in other remote databases in MySQL you usually enable Federated Storage Engine and use Federated tables. I don't remember much of the specifics but you may want to look those up in the documentation for whatever version of MySQL you are using.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy