CODEWITHSUNDEEP
amazon-rdsamazon-vpc
j-hurst
j-hurst

Reputation: 329

Multiple AWS RDS instances in a VPC

I have a feeling I know the answer, but could not find the actual answer anywhere.

If I have two RDS instances in a VPC, both running SQL Server, can I communicate between the two? As in reference a stored procedure from DB_123 in DB_456, or a table in DB_123, in a stored procedure in DB_456.

Upvotes: 0

Views: 485

Answers (1)

Ramon Leôncio
Ramon Leôncio

Reputation: 39

If both servers are on the same VPC, there aren't limitations on the internal communication between them.

If do you want to make queries between them through procedures, you should first link both SQL Servers and then follow the T-SQL below as stated at this topic.

SELECT * FROM [LinkedServer].[RemoteDatabase].[User].[Table]

Upvotes: 1

Related Questions