A Review of Incremental Data Load on Premises to Azure
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: 103 | Views: 336

Review Papers | Computer Science & Engineering | India | Volume 7 Issue 5, May 2018 | Popularity: 6.3 / 10


     

A Review of Incremental Data Load on Premises to Azure

Tejaswee Poya, Rahul Mishra


Abstract: This project explains to overcome with the disadvantages of legacy system to load data from on premises to azure. On legacy system Cloud based application should be offline while loading data into cloud which causes application unavailability, low customer satisfaction and impacting business revenue. This project helps in understanding the way of getting the advantages of the Cloud without having to migrate the entire database by just maintaining a copy of the data that needs to be accessible to internet-based users in Windows Azure SQL Database. The project allows SQL Server Management Studio (SSMS) to interface with the database engine and use Business Intelligence Development Studio (BIDS) to create a SQL Server Integration Services (SSIS) Package. SSIS will provide the mechanism necessary to upload the data from the SQL Server instance to SQL Azure and synchronize the uploaded data with existing data.


Keywords: Azure Cloud, SSIS Package, SSMS, SQL


Edition: Volume 7 Issue 5, May 2018


Pages: 1579 - 1580



Make Sure to Disable the Pop-Up Blocker of Web Browser


Text copied to Clipboard!
Tejaswee Poya, Rahul Mishra, "A Review of Incremental Data Load on Premises to Azure", International Journal of Science and Research (IJSR), Volume 7 Issue 5, May 2018, pp. 1579-1580, https://www.ijsr.net/getabstract.php?paperid=ART20182787, DOI: https://www.doi.org/10.21275/ART20182787

Similar Articles

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

Informative Article, Computer Science & Engineering, India, Volume 11 Issue 10, October 2022

Pages: 1394 - 1396

Optimizing Database Performance for Large-Scale Enterprise Applications

Yash Jani

Share this Article

Downloads: 105

Research Paper, Computer Science & Engineering, India, Volume 3 Issue 11, November 2014

Pages: 2041 - 2044

Optimization Technique for Efficient Dynamic Query Forms with NoSQL

Kavita Ozarkar, Rakesh Rajani

Share this Article

Downloads: 106

Comparative Studies, Computer Science & Engineering, India, Volume 2 Issue 4, April 2013

Pages: 193 - 195

Application for Detecting and Preventing SQL Injection Attacks using Web Service

Anuja A. Patil, Ketaki H. Pangu

Share this Article

Downloads: 106

Research Paper, Computer Science & Engineering, India, Volume 4 Issue 4, April 2015

Pages: 1292 - 1296

User Ranking Based Social Network Platform for Cloud Environment

Abhijeet Mishra, S.Niveditha, Debojyoti Sengupta, Rakesh Kumar

Share this Article

Downloads: 108

Research Paper, Computer Science & Engineering, India, Volume 2 Issue 4, April 2013

Pages: 242 - 245

An Approach to Detect and Prevent SQL Injection Attacks using Web Service

Shabnam R. Makanadar, Vaibhav V. Solankurkar

Share this Article
Top