Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ......
Transcript of Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ......
![Page 1: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/1.jpg)
![Page 2: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/2.jpg)
About.me
Sky ChangWindows Azure 微軟最有價值專家
天空的垃圾場blog.sanc.idv.tw
• ASP.NET MVC• Visual Studio ALM• Windows Azure
![Page 3: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/3.jpg)
Global Footprint
![Page 4: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/4.jpg)
Agenda
SQL Server 2014 in Azure VM
Deploy a database to SQL Server in a
Windows Azure Virtual Machine
SQL Server Backup and Restore to Azure Blob
Storage Service
Windows Azure SQL Database
Windows Azure SQL Data Sync
How to choose
![Page 5: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/5.jpg)
SQL Server 2014 in Windows Azure VM
![Page 6: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/6.jpg)
A Continuous Offering From Private to
Public Cloud
![Page 7: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/7.jpg)
SQL Server in Azure VM 完整兼容SQL Server產品
完全的控制OS與SQL Server
![Page 8: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/8.jpg)
快速部屬 隨選隨用
提供各種版本
建置速度超快
![Page 9: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/9.jpg)
注意事項 開啟端點
開啟防火牆
開啟DB端點
http://blog.sanc.idv.tw/2013/08/windows-azure-sql-server-in-vm.html
![Page 10: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/10.jpg)
![Page 11: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/11.jpg)
Deploy a database to SQL Server in a Windows Azure
Virtual Machine
![Page 12: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/12.jpg)
Deploy to Azure VM
SQL Server 2014新功能
VM需開啟port 11435
簡化原本繁雜的動作
![Page 13: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/13.jpg)
![Page 14: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/14.jpg)
SQL Server Backup and Restore to Windows Azure
Blob Storage Service
![Page 15: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/15.jpg)
Data-Tier Application Framework 替代傳統Script的作法
大大的簡化數據庫的部屬和遷移
提供dacpac和bacpac模式
支援SQL Server 2005以上版本
快速建立從無到有的db
![Page 16: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/16.jpg)
Backup and Restore to Azure Blob Storage 透過DAC機制
封裝成bacpac而非使用dacpac
提供快速備份與還原SQL Server
DB
SQL Server 2012 SP1 with cu2後開始支援
http://blog.sanc.idv.tw/2013/08/windows-azure-sql-serverdacazureblob.html
![Page 17: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/17.jpg)
![Page 18: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/18.jpg)
Windows Azure SQL Database
![Page 19: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/19.jpg)
A Continuous Offering From Private To
Public Cloud
![Page 20: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/20.jpg)
此Server不是一台機器…
![Page 21: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/21.jpg)
SQL Database SQL Server database是一種服務
完全的託管
自動支援企業級HA
應用程式的理想選擇
![Page 22: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/22.jpg)
![Page 23: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/23.jpg)
如何工作
Architecture Client Layer -
使用應用程式來與SQL Database溝通.
Services Layer –
Client layer和Platform layer之間的閘道.
Platform Layer –
實體和支持著Services layer的服務.
Infrastructure Layer –
最底層的硬體和OS.
![Page 24: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/24.jpg)
Create Database…
Use Familiar TechnologiesTransact-SQL
Languages
.NET Framework (C#, Visual Basic, F#) via ADO.NET
C / C++ via ODBC
Java via Microsoft JDBC provider
PHP via Microsoft PHP provider
Frameworks
OData, Entity Framework, WCF Data Services, NHibernate
Tools
SQL Server Management Studio (2008 R2 and later)
SQL Server command-line utilities (SQLCMD, BCP)
SQL Server Comparison專注於邏輯 vs. 實體的管理
Database and log files自動放置
高可用性副本 –每個資料庫都會自動放置三份
每個Table都需要建立clustered index
最大為150 GB
Unsupported SQL Server Features使用命令,分佈式的transactions, 分佈式的views
Service Broker
Common Language Runtime (CLR)
SQL Agent
Native Encryption
*Backup / Restore
![Page 25: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/25.jpg)
保護資料庫的兩種方式:
![Page 26: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/26.jpg)
Server identity and access control 支援SQL驗證( 不支援整合式驗
證 )
使用類似sa的登入帳號
兩種角色 :
loginmanager: 用來創建登入的伺服器安全角色
dbmanager:用來創建資料庫的伺服器安全角色
![Page 27: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/27.jpg)
Database identity and access control
需要使用關聯的用戶帳號登入.
登入會自動擁有dbo.
在Database裡面,dbo有充分的權利.
管理使用者透過CREATE / ALTER / DROP USER指令
使用sp_add_rolemember來給予角色權限
![Page 28: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/28.jpg)
Securing your data
利用IP來訪問與控管SQL
Database
默認情況下,沒有開放任何IP
透過SQL Database Portal和REST
API來管理
透過disable/enable來控制存取Windows Azure
![Page 29: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/29.jpg)
SQL Database Management Portal
透過網頁來設計tables, views, stored procs
執行查詢與下指令
SQL Server Data Tools (SSDT) Visual Studio IDE為主體的Database開發工具
輕易比對兩端的資料結構狀態
在連線與離線狀態下開發與測試
平台從SQL Server (2005 and above) 到 SQL
Database
![Page 30: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/30.jpg)
Connecting To SQL Database 支持TDS (Tabular Data Stream) protocol
over TCP/IP
SSL是必須的ASP.NET EXAMPLE:<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>
![Page 31: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/31.jpg)
Import & Export
輸出至Blob
可以定期的輸出備份
輸出的資料可以再Import進去
![Page 32: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/32.jpg)
![Page 33: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/33.jpg)
Windows Azure SQL Data Sync
![Page 34: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/34.jpg)
Data Synchronization 使用Microsoft Sync Framework technology
不需要任何的Code與配置設定
在SQL Database or SQL Server之間同步資料
完全自訂自己需要的商業需求
![Page 35: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/35.jpg)
Syncing Between SQL Server And SQL Database
Local
Cloud
E.g. 遷移期間E.g. 不同應用程式共享資料
多地點(分公司)
在各地點分享資料資料集中在cloud
![Page 36: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/36.jpg)
http://blog.sanc.idv.tw/2013/08/windows-azure-sql-database-data-sync.html
![Page 37: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/37.jpg)
How to choose
![Page 38: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/38.jpg)
SQL Database vs. SQL Server in Azure VM 是否需要完整兼容SQL Server產品
想要的控制權與成本
數據庫的規模與要求
http://blogs.msdn.com/b/windowsazure/archive/2012/06/26/data-series-sql-server-in-windows-azure-virtual-machine-vs-sql-database.aspx
![Page 39: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/39.jpg)
SQL Server inside Windows
Azure VM
Windows Azure
SQL Database
遷移現有的應用程式 快 中
建立新的應用程式 中 快
從建置時間來比較
![Page 40: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/40.jpg)
從花費比較
SQL Server inside
Windows Azure VM
Windows Azure
SQL Database
硬體管理 無 無
軟體管理 (Database & OS) 中 無
機器高可用性 自動 不需要
數據高可用性 需手動建立 內建標準功能
花費 中 低
![Page 41: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/41.jpg)
Scale Model
SQL Server inside
Windows Azure VM
Windows Azure
SQL Database
Scale-Up
X-Large VM
(8 cores, 14GB RAM,
up to 16 TB disk space)
不支援
Scale-Out 需手動設定 內建功能
![Page 42: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/42.jpg)
Control & Customize
SQL Server inside Windows
Azure VM
Windows Azure
SQL Database
OS and VM 完全控制 不可控制
SQL Server Database
兼容與功能完整支援SSIS, SSAS, SSRS
較大的SQL Server功能
![Page 43: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/43.jpg)
Hybrid
SQL Server inside
Windows Azure VM
Windows Azure
SQL Database
加入AD 可 不可能
Azure Data Sync同步 支援 支援
![Page 44: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/44.jpg)
Manageability
SQL Server inside
Windows Azure VM
Windows Azure SQL
Database
資源管理與安全級別 SQL Instance/VM Logical DB Server
工具支援現有的SQL Server tools
包含SSMS,
System Center和SSDT
現有的SQL Server
tools 包含SSMS,
System Center和SSDT
![Page 45: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/45.jpg)
如何獲得百萬跑車?2013/09/30前,只要依照規定啓用MSDN訂閱隨附的Windows Azure 權益,即有機會將北美預估
零售價 118,600 美元的 Aston Martin V8 Vantage Coupe 開回家.
詳情請參閱Windows Azure 網站 : http://www.microsoft.com/taiwan/windowsazure/
![Page 46: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/46.jpg)
start now.http://WindowsAzure.com
![Page 47: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/47.jpg)
blog.sanc.idv.twThank You
![Page 48: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/48.jpg)
TechDays 2013http://www.microsoft.com/taiwan/techdays2013/
![Page 49: Windows Azure Overview · PDF file• Visual Studio ALM • Windows Azure. ... 封裝成bacpac而非使用dacpac ... 平台從SQL Server (2005 and above) 到SQL](https://reader033.fdocument.pub/reader033/viewer/2022042509/5a85bf367f8b9afc5d8c98ed/html5/thumbnails/49.jpg)