Azure SQL Databases - Introduction and Migration Overview
Explore the benefits, capabilities, editions, and migration tools for Azure SQL Databases. Learn about the advantages, best practices, and demo scenarios for seamless database migration to Azure.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Azure SQL Databases - Introduction and Migration Kumar Bijayanta 2/14/2015
Azure SQL Databases Database as a service. Hosted on Azure VMs. Pay as you go. No upfront cost, no termination fees. Price starting from 0.41 rs/hr. Access over internet. Easily Scalable.
Capabilities - Close to zero maintenance. Predictable performance. Availability backed by replicas. Data protection via auditing , restore and geo- replication. Easily scalable. Automated backup and restore.
Editions Web and Business - unpredictable performance. 5 GB - 150 GB Supported until September. Basic, Standard and Premium Predictable performance upto 500 GB. DTUs - a blend of memory, CPU, I/O, etc.
Demo Create a database. Run queries against it. Scale Database. Backup and Restore.
Advantages Close to zero maintenance. Create database in seconds. Code near data. Guaranteed predictable performance. Easily scalable. Lower price. Built-in HA, backup and restore
Database migration Size Time to migrate directly proportional to size. Transactions could be throttled. Complexity Schema changes. Features not supported in Azure.
Migration tools Azure SQL Database Import and Export Service. Database Copy. SQL Server Import and Export Wizard. SQL Database Migration Wizard. SQL Server Migration Assistant - From Accss/DB2/Oracle/MySQL BCP. SQL Server Integration Services.
Demo Migration that requires database to be modified. Clean errors and migrate.
Migration Best Practices Pick S2 or higher edition for the migration duration. Copy bacpac file to Azure blob. Run the source database trough SQL database migration wizard. Separate operations into smaller batches. Retry logic.
