Replication of MS SQL databases via FTP?

Question

Database

Please do not delve into why via FTP or why MS SQL.

There is very little information on the Internet, they offer either to upload the transaction log via FTP or use SSIS.

And here and there there are problems with the side that applies the change log to itself. Has anyone come across?

Answer 1

Replication in MSSQL terminology is the repetition of transactions through a direct tcp connection. those. the very definition of "MS SQL database replication via FTP" is nonsense. Log Shipment via ftp is possible, but copying will have to be configured manually, which is possible. There are many nuances, but I would not go through SSIS.

Answer 2

I don’t want to mislead, but isn’t the full snapshot laid out on ftp, after which the database is “restored”?