January 30, 2019 at 8:24 am
Hi,
We have recently implemented a new PLM application - it's hosted via a third party hosting provider ( we have RDP access to the box ). We'd like to replicate from this server to a SQL server we have hosted in AWS ( EC2 instance running SQL Server ).
We already have some internal transactional replication going on but from what I read I can't just setup in the same way - I've read some articles about web merge replication etc.
We don't have any VPNs setup between the two server it will be a direct IP connection ( but might review that ).
SR.
January 30, 2019 at 9:53 am
Are you asking about setting up replication across the Internet? I assume you want transactional from your hosting provider to a VM in EC2. This is all about authentication and security. If the two sides can authenticate the actions, this will work. Are these separate domains/workgroups?
If you don't have a VPN, and you should, then you can firewall the two sides to only allow communications between those two IPs.
January 30, 2019 at 10:01 am
Steve Jones - SSC Editor - Wednesday, January 30, 2019 9:53 AMAre you asking about setting up replication across the Internet? I assume you want transactional from your hosting provider to a VM in EC2. This is all about authentication and security. If the two sides can authenticate the actions, this will work. Are these separate domains/workgroups?If you don't have a VPN, and you should, then you can firewall the two sides to only allow communications between those two IPs.
Hi no VPN but we can setup firewalls etc to allow permissions. Separate domains yes. Any practical guides on doing it?
January 30, 2019 at 11:48 am
Not that I know of either. There used to be a note at MS Support, but the article looks pulled.
I did find these:
https://dba.stackexchange.com/questions/66513/sql-server-cross-domain-transcational-replication
https://stackoverflow.com/questions/19730218/setup-replication-on-two-database-on-different-domain
https://dba.stackexchange.com/questions/52662/is-replication-possible-on-two-different-domains
What this comes down to is authentication for the agent processes to talk to each other.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply