Hi, I was wondering if SC can have connection to 2 SQL Servers in 2 completely different networks? In other words, one SQL Server is in 192.168.23.113 and another SQL Server is in 10.100.41.2. None of the SQL Servers are GP; we just want to exchange data between them. Thanks in advance for your reply.
msafi, assuming sql source and sql destination then – yes. in both source and destination, you would enter the sql creds and point to the source & dest separately for each. So there shouldn’t be any issues that these are separate machines. Patrick
If you would like to submit an answer or comment, please sign in to the eOne portal.