Downloads: 115 | Views: 241
Informative Article | Information Technology | India | Volume 9 Issue 7, July 2020 | Popularity: 6.3 / 10
SQL Server Replication Using FTP Server
Amol Gawas, Vinod Kochu
Abstract: 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.
Keywords: Sql Server Replication, Transactional Replication, FTP, IIS server, cross domain
Edition: Volume 9 Issue 7, July 2020
Pages: 894 - 896
Make Sure to Disable the Pop-Up Blocker of Web Browser