14,494 questions
Hi @Leo D ,
Please refer to this link:
Hope this would give you some help.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it.
SQL Server Transactional Replication and Secure FTP
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 34%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Leo D
0
Reputation points
Hello, We are planning to use Transactional Replication feature with setup of remote Pull Subscription. Currently we have Secure FTP server configured and up and running (Port 22). Question is - Is it possible to use Secure FTP with Replication to re-initialize Replication Snapshot for Remote pull Subscription? I know that FTP is supported to deliver Replication Snapshot files to Remote Subscriber, but it is unclear to me if Secure FTP can be used instead. Please let me know if it is possible or not. (I am aware of alternative initialization option with DB backup, unfortunately it cannot be used for re-initialization of the Subscriber). If Yes - maybe you can point me to related documentation link with more details. Thank you, Leo
SQL Server Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,586 Reputation points2023-04-20T06:43:07.4533333+00:00 Hi @Leo D , We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated. Best regards, Seeya
-
Seeya Xi-MSFT 16,586 Reputation points
2023-04-28T01:44:19.0233333+00:00 Hi @Leo D ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
-
Leo D 0 Reputation points
2023-05-03T15:26:15.3866667+00:00 Hello Seeya,
Thank you for the reply and the link provided. and my apology for late reply back.
I am familiar with the link provided. My question is - if we use third party SFTP server solution (with port 22) - can replication snapshot be delivered to remote Subscriber (external to our network) via SFTP, not regular FTP ?
Thank you,
Leo Dvosis
Sign in to comment