Our staging database is stored on Amazon Web Services EC2. I'm trying to create a database link from the server to an external database because, unfortunately, there's data in another system that we have to join our tables with, and it has to stay there.
On my local I can create a linked database easily in SSMS. But I can't do that for staging because AWS doesn't allow any users to have the sysadmin role. Supposedly AWS lets you do some things through it that the sysadmin role can do, but I can't find a definitive list anywhere for that.
Is there anyway to created linked servers in AWS?
Aucun commentaire:
Enregistrer un commentaire