data transfer between 2 sql

  • I have one sql on my web server and another running behind my firewall. What is the best way to transfer data from web sql to LAN sql? Obviously my web sql can not see the LAN ssql but LAN sql can see web SQL.I need realtime replication

  • You can try configuring the web sql as a publisher and a distributor. Don't allow anonymous subscriptions, but define your LAN sql as an allowed subscriber. Then try a creating a pull subscription on the LAN sql.


    Cheers,
    - Mark

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply