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 réponse
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
EXPERT
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions