Linked server connection from on-prem SQL Server to RDS MySQL?

0

I have a SQL Server database and a MySQL database (both on-prem) currently connected via a Linked Server connection.

I'm exploring migrating the MySQL database to RDS (SQL Server must remain on-prem), but would like to know if linked server connectivity will still be possible between MySQL on RDS and on-prem SQL Server. Has anyone successfully done this/know if it's currently supported, or can advise on any pitfalls for this approach? Thanks.

已提問 1 年前檢視次數 992 次
1 個回答
1

There is a blog that shows how to do this with MSSQL Server - https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/

I recently had asked this question about a link from on-prem MSSQL Server to RDS MySQL or RDS PostgresSQL on an internal forum and one of my colleagues who is a database expert had mentioned this and also shown a demo to my customer -

"Linked servers helps/enables the SQL Server Database to read the data from remote sources and run different commands against the remote database servers. We can create a SQL Server linked server that can access to mysql database running on RDS. Linked server can be created using SQL Server Management studio. Create an ODBC connection to external data from SQL Server Management studio. Create DSN (Data Source Name ) using ODBC connector. After successful ODBC connection to the MySQL server running on the AWS RDS, open SQL Management Studio and connect to MSSQL Server. Under Server Objects add a New Linked Server and select other data source as an options and enter the DSN name that has been created in the previous step. By this we should be able to connect to the MYSQL Server running in Amazon RDS."

profile pictureAWS
專家
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南