1 / 16

virtual techdays

INDIA │ 22-23 November 2010. virtual techdays. SQL Azure Data Sync. Shilpa Nirmale │ Associate Manager, Accenture. INDIA │ 22-23 November 2010. virtual techdays. Introduction to SQL Azure Data Sync SQL Azure Overview Tools available for migrating data from SQL Server to SQL Azure

gyan
Download Presentation

virtual techdays

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. INDIA │ 22-23 November2010 virtual techdays SQL Azure Data Sync Shilpa Nirmale│ Associate Manager, Accenture

  2. INDIA │ 22-23 November2010 virtual techdays • Introduction to SQL Azure Data Sync • SQL Azure Overview • Tools available for migrating data from SQL Server to SQL Azure • SQL Azure Data Sync – Introduction • Why Data Sync Service? • SQL Azure Data Sync CTP1 (Available Now) • Features • Demo using SQL Azure Labs • SQL Azure Data Sync CTP2 ( Coming Soon) • Features • Video • Questions? S E S S I O N A G E N D A

  3. INDIA │ 22-23 November2010 virtual techdays • SQL Azure • Microsoft® SQL Azure™ Database is a cloud-based relational database service built on SQL Server® technologies. • Highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud • Developers do not have to install, setup, patch or manage any software. High availability and fault tolerance is built-in and no physical administration is required. • Benefits • No physical administration required – software installation and patching is included • High availability and fault tolerance are built in • Simple provisioning and deployment of multiple databases • Scale databases up or down based on business needs • Pay as you use model Introduction to SQL Azure Data Sync SQL Azure Overview

  4. INDIA │ 22-23 November2010 virtual techdays • Tools available for migrating data from SQL Server to SQL Azure • Codeplex - SQL Azure Migration Wizard. • BCP • SQL Server 2008 R2 – SSMS • Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit) • Microsoft Sync Framework 4.0 Oct 2010 CTP The Microsoft Sync Framework 4.0 October 2010 CTP is built on top of Sync Framework 2.1 and it extends the Sync Framework capabilities of building offline application to any client platform that is capable of caching data. Introduction to SQL Azure Data Sync SQL Azure Overview

  5. INDIA │ 22-23 November2010 virtual techdays • What is SQL Azure Data Sync? • Data synchronization service hosted in Microsoft Data Center. • Built on Microsoft Sync Framework technologies • Provides bi-directional data synchronization and data management capabilities. Introduction to SQL Azure Data Sync SQL Azure Data Sync

  6. INDIA │ 22-23 November2010 virtual techdays • Why we need sync service? Introduction to SQL Azure Data Sync SQL Azure Data Sync • Challenges with connecting to central data source through VPN/internet • Network Requirements • Data Access Speeds • Single Point of Failure • Server Scalability • Solution: Data Synchronization • To implement an Occasionally Connected Application (OCA). • Synchronize the local database with central data source only on demand basis or on periodic basis at a particular schedule.

  7. INDIA │ 22-23 November2010 virtual techdays • Benefits Introduction to SQL Azure Data Sync SQL Azure Data Sync • SQL Azure to SQL Azure Sync [CTP1] • Scaling up is expensive, but Scaling Out is cost effective by distributing load across set of SQL Azure Databases and keep the databases synchronized using SQL Azure Data Sync Service. • SQL Server to SQL Azure Sync [CTP2] • Critical Need to provide ability for remote /mobile users to get access to the same information as they get access in their organizations.

  8. INDIA │ 22-23 November2010 virtual techdays • Features Introduction to SQL Azure Data Sync • SQL Azure Data Sync CTP1 (Available Now) • Use CTP1: • To scale-out data access across multiple databases • To Synchronize data between SQL Azure databases in different data centers • Elastic Scale • Helps Scale Out the SQL Azure during high load • No-Code Sync Configuration • Easily define data to be synchronized • Schedule Sync • Choose how often data is synchronized • Conflict Handling • Handle issues where same data is changed in multiple locations • Logging and Monitoring • Administration capabilities for tracking data and monitoring potential issues • Prerequisites : • An active SQL Azure account. • Windows Live ID • Two SQL Azure Databases in same or different data centers. • Credentials for accessing the server. • A firewall exception for Microsoft Services

  9. INDIA │ 18-20 august2010 virtual techdays DEMO: How to use SQL Azure Data Sync CTP1

  10. INDIA │ 22-23 November2010 virtual techdays Demo How to use SQL Azure Data Sync CTP1

  11. INDIA │ 22-23 November2010 virtual techdays • Features Introduction to SQL Azure Data Sync • SQL Azure Data Sync CTP2 (Coming Soon) • Use CTP2 : • To scale-out data access across On-premise Database and SQL Azure. • To Enable new scenarios spanning enterprise and cloud • On-Premise to Cloud Symmetry • Sync between SQL Server to SQL Azure • Extending Data to Retail and Remote Offices • Synchronize data from SQL Azure to Retail/Remote offices. • Schedule Sync • Choose how often data is synchronized • Conflict Handling • Handle issues where same data is changed in multiple locations • Logging and Monitoring • Administration capabilities for tracking data and monitoring potential issues • Prerequisites : • An active SQL Azure account. • Windows Live ID • One SQL Azure Database and one or more On-Premise database on SQL Servers • Credentials for accessing the server on SQL Azure. • A firewall exception for Microsoft Services

  12. INDIA │ 22-23 November2010 virtual techdays VIDEO: How to use SQL Azure Data Sync CTP 2 PDC10 Video │ SQL Azure Data Sync

  13. INDIA │ 22-23 November2010 virtual techdays VIDEO: How to use SQL Azure Data Sync CTP 2 PDC10 Video │ SQL Azure Data Sync

  14. INDIA │ 22-23 November2010 virtual techdays PDC 10 Video Introduction to SQL Azure Data Sync

  15. INDIA │ 22-23 November2010 virtual techdays • SQL Azure Data Sync • http://www.microsoft.com/en-us/sqlazure/datasync.aspx Benefit/Details • SQL Azure Data Sync Service Walkthrough • https://www.sqlazurelabs.com/ • Introduction to Sync Framework Database Synchronization • http://msdn.microsoft.com/hi-in/sync/bb887608(en-us).aspx Benefit/Details • PDC10 – Presentation for Introduction to SQL Azure Data Sync • http://az8714.vo.msecnd.net/presentations/CS58-Cavanagh.pptx RESOURCES

  16. THANKS│ 22-23 November2010 virtual techdays Email ID : shilpa.nirmale@accenture.com

More Related