1 / 18

Migrating Data to SQL Azure

Migrating Data to SQL Azure. Arunraj Chandrasekaran http://www.SQLXpertise.com Twitter - @ SQLXpertise. June 21, 2011. Agenda. Introduction What data can be moved to SQL Azure ? Preparation for Migration Migration Tools SQL Server / Azure Migration Assistants Access MySQL

gamba
Download Presentation

Migrating Data to SQL Azure

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. Migrating Data to SQL Azure ArunrajChandrasekaran http://www.SQLXpertise.com Twitter - @SQLXpertise June 21, 2011

  2. Agenda • Introduction • What data can be moved to SQL Azure ? • Preparation for Migration • Migration Tools • SQL Server / Azure Migration Assistants • Access • MySQL • SQL Azure Migration Wizard • DAC Database Import / Export • SQL Azure Sync Service • SQL Azure Database Copy • SSMS Generate Scripts, BCP, SSIS

  3. Introduction • SQL Azure Database • Highly available, and scalable cloud database service built on SQL Server technologies • SQL Azure Data Sync Service • Cloud-based data synchronization service built on Microsoft Sync Framework technologies. It provides bi-directional data synchronization and data management capabilities allowing data to be easily shared between multiple SQL Azure databases and between on-premises and SQL Azure databases

  4. What data can be moved to SQL Azure ? SQL Server SQL Azure SQL Azure SQL Server

  5. Preparation for Migration • Clustered Index required for All Tables • Connection Handling • Database Size and Scaling • Features not supported • Encryption • SQL CLR • Cross Database Queries • SQL Server Agent • Database Mail • Full Text • Service Broker

  6. Migration Tools

  7. SQL Server Migration Assistant DEMO • Free Tool available with Support from Microsoft • Supports Migration to SQL Server and Azure • Access (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4b37df74-7522-41cf-9c1a-01b6415d9608) • MySQL (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ac017a90-3b53-49b6-92a7-0f91623ef530) • Sybase (http://go.microsoft.com/?linkid=9771006) • Oracle (Currently Supports SQL Server, SQL Azure support will be released in future) (http://www.microsoft.com/download/en/details.aspx?id=23945) • Migrates Schema and Data

  8. SQL Azure Migration Wizard DEMO Free Available on http://sqlazuremw.codeplex.com/ Support SQL Server 2005 / 2008 / 2008 R2 migration Supports Schema Analysis and fixing of basic issues

  9. DAC Import / Export v 2.0 DAC Framework V 2.0 available in www.SQLAzureLabs.com as CLI Support for Schema and Data Support Export data from SQL Azure and Import to SQL Server and vice versa For more information about API, Please read http://msdn.microsoft.com/en-us/library/ff381683(SQL.100).aspx

  10. DAC Import / Export v 2.0 DEMO Export Schema and DataDacImportExportCli.exe -s serverName.database.windows.net -d databaseName -f C:\filePath\exportFileName.bacpac -x-u userName -p password Import Schema and DataDacImportExportCli.exe -s serverName.database.windows.net -d databaseName -f C:\filePath\exportFileName.bacpac -i –edition business –size 30 -u userName -p password Drop Database and DACPACDacImportExportCli.exe -s serverName.database.windows.net -dropdatabaseName -u userName -p password

  11. SQL Azure Data Sync Service DEMO Built on Sync Framework No Code Easy to configure Support Bi-Directional and Unidirectional Sync Conflict Handling Logging and Monitoring Change Tracking

  12. SQL Azure Data Sync Service DEMO • Supports Sync of selected Tables • Batch Transfers • Snapshot Isolation enabled for SQL Server databases • Currently in CTP2 (http://connect.microsoft.com/sqlazurectps) • No Support for Views • Future Support • Row Filter • Option to define Conflict resolution policy

  13. SQL Azure Database Copy DEMO Supports creating databases within SQL Azure server transiently Supports across SQL Azure servers as well UsageCREATE DATABASE destination_database_name AS COPY OF [source_server_name.] source_database_name

  14. SSMS Generate Scripts DEMO Supports only Schema

  15. BCP DEMO Supports exporting or import Text Files or CSV files No support for Schema

  16. SSIS / SQL Server Import Export Wizard DEMO Support Data migration No support for Schema

  17. Free SQL Azure 30 Day Pass

  18. References SQL Azure MSDN - http://msdn.microsoft.com/en-us/windowsazure/sqlazure/cc500985 SQL Azure Forums - http://social.msdn.microsoft.com/forums/en-US/ssdsgetstarted/threads SQL Azure Team Blog - http://blogs.msdn.com/b/sqlazure/ Free Training Videos / Demos - http://sqlazure.codeplex.com/ SQL Azure Labs - https://www.sqlazurelabs.com/ My Blog – http://www.SQLXpertise.com

More Related