随笔分类 -  SQL Azure

摘要:Foreword When we do some test that need several VMs, we can use PowerShell script or CmdLets to implement what we want. Keywords PowerShell, New-AzureVMConfig, New-AzureProvisioningConfig, New-Azur... 阅读全文
posted @ 2014-05-07 22:18 EricWen 阅读(384) 评论(0) 推荐(0)
摘要:Download any version source code of Windows Azure Powershell from https://github.com/Azure/azure-sdk-tools/releases Downdload Wix ToolSet from http://wix.codeplex.com/releases/view/115492... 阅读全文
posted @ 2014-05-07 19:30 EricWen 阅读(282) 评论(0) 推荐(0)
摘要:怎样备份SQL Azure数据库到本地或者云存储Storage,可以使用SQL Database Import Export 的功能。 具体操作如下: 用SSMS链接SQL Azure数据库 注意:服务器名称可以从管理网站上获得,登录名不要加@服务器名。 右键要导出的数据库名称,选择任务(Task)->导出数据(Export Data-tier Application) ... 阅读全文
posted @ 2013-11-26 22:55 EricWen 阅读(3283) 评论(1) 推荐(1)
摘要:如何自动备份SQL数据库到Storage呢。前提条件需要SQL Server2012 SP1 CU2或更高版本1. 备份SQL Azure数据库到云存储Storage1)在SQL Server Management Studio中创建Storage存储身份认证创建Storage身份认证信息脚本样例如下:IF NOT EXISTS(SELECT * FROM sys.credentialsWHERE credential_identity = 'mycredential')CREATE CREDENTIAL mycredential WITH IDENTITY = 'my 阅读全文
posted @ 2013-11-21 22:12 EricWen 阅读(1002) 评论(0) 推荐(0)