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: 180

Review Papers | Computer Science & Engineering | India | Volume 7 Issue 5, May 2018

A Review of Incremental Data Load on Premises to Azure

Tejaswee Poya [2] | Rahul Mishra [5]

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

How to Download this Article?

Type Your Valid Email Address below to Receive the Article PDF Link

Verification Code will appear in 2 Seconds ... Wait