Transaction Replication using Secure FTP

  • How to do Transaction Replication using Secure FTP?. i know you can setup using regular FTP, but i want to use secure FTP.

  • This was removed by the editor as SPAM

  • i am suprised that no one responded to my query, wondering how people do replication over internet using secure FTP? there should be way doing it

    can someone direct me atleast where i will get information, some links??

    Gufran

  • Not use by what you mean with secure FTP.

    SQL replication will use FTP. Security depends on the network security, not SQL configuration.

  • FTP sends files in clear plain-text exposing them to the plethora of bad guys out there who have nothing better to do than violate the privacy of others, pilfer confidential information such as credit card information, and attempt to obtain classified information that could compromise national security.

    If you are setting replication using FTP over internet, you are vunerable to hackers.

    Various products have been developed to resolve the security problems with FTP. These products vary in their solution to FTP security. Vendors who make these products have taken FTP and secured it by building in strong authentication and encryption.

    Most secure FTP products use encryption and X.509 certificates. X.509 certificates are composed of multiple attributes including public keys used for asymmetric public key cryptography.

    My questions is, how do i use secure FTP (SFTP) for replication over internet??

  • I am looking for a solution to a similar problem myself...

    I want to export new content from a db table to a remote server on a daily basis, over a secure connection

    I have come to the conclusion that the easiest way to do this is to use a Secure FTP client that supports command line operation, and to call this from a dts package.

    I haven't found a suitable (windows) ftp client yet - but I'm fairly certain one must exist...

Viewing 6 posts - 1 through 5 (of 5 total)

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