Transcript Introduction To Windows Azure SQL Database

Single Database
!
Multiple Replicas
Replica 1
DB
Replica 2
Replica 3
Replica 4
Single Primary
Supported
Unsupported
ADO.Net .Net 3.5 SP1 and 4.0
OleDB
ODBC - SNAC 10
Entity Framework .Net 3.5 SP1 and 4.0
SQL Server 2008 Driver for PHP v1.1
Supported
Unsupported
TCP/IP over port 1433
Dynamic ports
Named pipes
Shared memory
Supported
Unsupported
SQL Auth
Windows Auth
1.
1.
2.
2.
3.
3.
4.
<connectionStrings>
<addname="AdventureWorks"connectionString=
"Data
Source=[server].database.windows.net;
Integrated Security=False;
Initial Catalog=ProductsDb;
User Id=[login];
Password=[password];
Trusted_Connection=False;
Encrypt=true;"
providerName="System.Data.SqlClient"/>
</connectionStrings>
5.
6.
7.
8.
9.
10.
•
The Transient Fault Handling Application Block
SQL Database access from
within
MS Datacenter (Azure compute)
Application/ Browser
SQL Database Access from
outside
MS Datacenter (On-premises)
SQL Database access from
within and outside
MS Datacenter (On-premises & Azure
Compute)
App code/ Tools
App code/ Tools
)
T-SQL (TDS)
Windows
Azure
SQL Database
Code Near
Windows
Azure
Data Sync
(ASP.NET)
(ASP.NET
Windows
Azure
SQL Database
App App
Code
Code
T-SQL (TDS)
SOAP / REST
HTTP / HTTPS
App App
Code
Code
(ASP.NET)
(ASP.NET
)
T-SQL (TDS)
SQL Database
SQL Database
Code Far
Hybrid
http://msdn.microsoft.com/en-us/library/ee336267.aspx
http://msdn.microsoft.com/en-us/library/windowsazure/ff394115.aspx
Migration Options
• SQL Server Management Studio
•
Data-tier Application (DACPAC & BACPAC)
•
Generate Script Wizard (SSMS)
• Visual Studio
• SQL Server Data Tools
• SQLAzureMW
• Useful for catching unsupported features in SQL Azure
• Moves data efficiently
• Unofficially supported
Generate Script Wizard
•
Scenario
•
•
Pros
•
•
Migration of schema and/or data with fine grain control.
Native support for SQL Azure Schema options: “Engine Type = SQL Azure”
•
Ensures correct options and settings are applied for the TSQL script generation.
•
Requires explicit action on unsupported objects.
Cons
•
Verbose – INSERT Statements instead of raw data
•
Data is scripted with a fixed 100 row batch size.
•
•
Edit “GO” statements between small batches
Round-trip Efficiency
•
Use “SET NOCOUNT ON”
Generate Script Wizard
Migrating Databases to SQL Database
•
Scenarios
•
•
Self contained package for moving schema easily through the development lifecycle
What is a DAC Pack?
•
Single unit for authoring, deploying, and managing the data-tier objects
•
Development Lifecycle (Visual Studio)
•
•
•
Editing DACs
•
Schema and DB Code Development,
•
Code Analyses, Deployment Policy Settings,
•
Schema Comparison and more…
Building DACs – the self contained database package
Management Lifecycle (SSMS)
•
Managing DACs
•
Registering existing database as DACs
•
Deploying and Upgrading databases using DACs,
Data-tier Application
Migrating Databases to SQL Database
SQLAzureMW
Migrating databases to SQL Database
Scenario/Tool
Move SQL Schema
SQL Azure Generate
Migration
Script
Wizard
Wizard
√
√
DACs
BAC
√
√
BCP
Efficient
More work
Move Data
Move Large Data
√
√
√
√*
√*
√*
√*
Limited
NA
*
No Retry
Database Size
Price Per Database Per Month
0 to 100 MB
Flat $4.995
> 100 to 1 GB
Flat $9.99
> 1GB to 10 GB
$9.99 for first GB, $3.996 per additional GB
> 10 GB to 50 GB
$45.96 for first 10 GB, $1.996 for each additional GB
> 50 GB to 150 GB
$125.88 for first 50 GB, $0.999 for each additional GB
Outbound Data Transfer
US and Europe
Asia
First 5 GB / Month 1
Free
Free
5 GB - 10 TB 2 / Month
$0.12 per GB
$0.19 per GB
Next 40 TB / Month
$0.09 per GB
$0.15 per GB
Next 100 TB / Month
$0.07 per GB
$0.13 per GB
Next 350 TB / Month
$0.05 per GB
$0.12 per GB
Greater than 500 TB / Month
Contact us
Contact us