Downloads: 126 | Weekly Hits: ⮙1 | Monthly Hits: ⮙1
Research Paper | Computer Science & Engineering | India | Volume 7 Issue 5, May 2018
Research Paper on Incremental Data Load on Premises to Azure
Tejaswee Poya [2] | Rahul Mishra [5]
Abstract: This project explains to overcome with the disadvantages of legacy process to move data from SQL server to SQL azure database. On legacy system Cloud based internet application need to be offline while loading data into Azure cloud database, which causes application unavailability and low customer satisfaction. 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: 1669 - 1671
Similar Articles with Keyword 'Azure Cloud'
Downloads: 103
Review Papers, Computer Science & Engineering, India, Volume 7 Issue 5, May 2018
Pages: 1579 - 1580A Review of Incremental Data Load on Premises to Azure
Tejaswee Poya [2] | Rahul Mishra [5]
Downloads: 129
Survey Paper, Computer Science & Engineering, India, Volume 4 Issue 12, December 2015
Pages: 662 - 665Microsoft Windows Azure: Developing Applications for Highly Available Storage of Cloud Service
Pratiksha P. Nikam | Ranjeetsingh S. Suryawanshi