SQL Server Replication Using FTP Server

Sql server supports multiple high availability solutions. Replication tends to have many advantages but these come with a complex architecture. Sql server allows replication to be configured between two different servers without the other one being of sql server origin. Replication is done by synchronizing data objects. The process is one way as well as two way depending on the business requirement. The usual setup includes sql server at both source and destination, the internals then use replication components to sync data objects between two servers. Replication strictly involves sharing of database logs which needs to be pushed to the other server or the server needs to pull the logs. This criteria requires the two servers to be in same domain so that this sharing takes place with respect to security policies defined by Microsoft Sql server. The real issue arises when the same setup needs to be done between two different domains. In this paper, is demonstrated a solution to the projected issue, which uses file transfer protocol server as mediator between two servers and establishing the syncing process of sql server replication.