SQL Server Replication Using FTP Server
International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
Call for Papers | Fully Refereed | Open Access | Double Blind Peer Reviewed

ISSN: 2319-7064


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


Text copied to Clipboard!
Amol Gawas, Vinod Kochu, "SQL Server Replication Using FTP Server", International Journal of Science and Research (IJSR), Volume 9 Issue 7, July 2020, pp. 894-896, https://www.ijsr.net/getabstract.php?paperid=SR20712032505, DOI: https://www.doi.org/10.21275/SR20712032505

Similar Articles

Downloads: 2 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1

Research Paper, Information Technology, India, Volume 10 Issue 8, August 2021

Pages: 1309 - 1318

Performance Analysis of Data Exchange Protocols in Cloud Environments

Sai Kumar Reddy Thumburu

Share this Article

Downloads: 4 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1

Research Paper, Information Technology, India, Volume 8 Issue 11, November 2019

Pages: 2061 - 2067

Data Analytics: Data Mesh Architecture and Its Implications for Data Management

Kishore Gade

Share this Article

Downloads: 106

Research Paper, Information Technology, Kenya, Volume 7 Issue 4, April 2018

Pages: 593 - 598

Intelligent Agents Based Fuzzy Liquidity Management Technique for Mobile Money Transfer

Millicent Murithi, George Okeyo, Michael Kimwele

Share this Article

Downloads: 142 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1

Informative Article, Information Technology, India, Volume 4 Issue 12, December 2015

Pages: 1568 - 1570

Firewall: A Security Point of a Network

Manoj Parmar

Share this Article
Top