Downloads: 115 | Views: 279
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
Similar Articles
Downloads: 2 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Research Paper, Information Technology, India, Volume 10 Issue 8, August 2021
Pages: 1309 - 1318Performance Analysis of Data Exchange Protocols in Cloud Environments
Sai Kumar Reddy Thumburu
Downloads: 4 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Research Paper, Information Technology, India, Volume 8 Issue 11, November 2019
Pages: 2061 - 2067Data Analytics: Data Mesh Architecture and Its Implications for Data Management
Kishore Gade
Downloads: 106
Research Paper, Information Technology, Kenya, Volume 7 Issue 4, April 2018
Pages: 593 - 598Intelligent Agents Based Fuzzy Liquidity Management Technique for Mobile Money Transfer
Millicent Murithi, George Okeyo, Michael Kimwele
Downloads: 142 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Informative Article, Information Technology, India, Volume 4 Issue 12, December 2015
Pages: 1568 - 1570Firewall: A Security Point of a Network
Manoj Parmar