- 新しい順
- 投票が多い順
- コメントが多い順
Hi
As you noted, federated queries in Amazon Redshift currently support Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL-Compatible Edition, Amazon RDS for MySQL, and Amazon Aurora MySQL-Compatible Edition only. As you are looking for simple architecture, you can migrate MS SQL data to Aurora PostgreSQL and use Babelfish for Aurora PostgreSQL. You don't need to do any changes on the application side. Babelfish enables Aurora PostgreSQL to work with commonly-used SQL Server query tools, commands, and drivers. https://aws.amazon.com/rds/aurora/babelfish/
Thank You Joseph
It's a bit more complicated as I don't own the application/product and the source Prod RDS MS-SQL. It won't be possible for me to initiate or motivate for the change. Yes the architecture team will look to in future to have 1 RDS (PostgreSQL) but that's on the roadmap for 2025 Its only roughly 5 tables, are there other options perhaps, Could I have replication from MS-SQL to the PostgreSQL, thinking out loud.
Please Help, any ideas
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 1年前
- AWS公式更新しました 1年前