Windows Azure Learning Note (4) - Updating
来源:互联网 发布:teracopy软件 编辑:程序博客网 时间:2024/05/18 02:36
Moving an Existing Database to the Cloud
The SetForeignKeyEnabledStatus stored procedure will be used todisable foreign key constraints during data migration. This will permit you to load your tables in whatever order is convenient without regard to primary key / foreign key relationships. You will run this stored procedure again when data migration is complete to re-enable all of the foreign key constraints.
The SetIndexEnabledStatus stored procedure will be used todisable all non-clustered indexes during data migration. This speeds up the data loading process. You will run this stored procedure again when data migration is complete to rebuild all of the non-clustered indexes.
ExportTableData.cmd
bcp dbo.MyTableName out MyTableName.dat -n -S MySqlServerName -T
Note: Use the–n parameter to use the “native” file format for export. The native formatimproves performance on import by avoiding unnecessary conversions. Use the–T parameter to connect to SQL Server using your Windows credentials.
bcp dbo.MyTableName in MyTableName.dat -n -S myserver.database.windows.net -Umysqladminuser@myserver -Pmysqladminuserpassword -E
Managing Cache Expiration and Resource Versioning
// save to blob and set its TTL
dstBlob.Properties.ContentType = "image/jpeg";
dstBlob.Properties.CacheControl = "public, max-age=" + ttl.ToString("N0");
dstBlob.SetProperties();
Using Versioning to Invalidate Content Cached by the CDN
In order to changes propagated immediately to clients. First of all, you need to turn on "Query String" to the CDN
Content stored by a CDN edge server remains in its cache for as long as is specified by the Cache-Control header on the source blob. This means that clients requesting the resource receive a copy from the server’s cache until the resource’s TTL expires. Only then does the server retrieve an updated copy from its source.
Notice that the URL of the image downloaded from the CDN includes a query parameter with a version number and that the image immediately updates to match the source image in blob storage despite the fact that the remaining TTL is not yet zero. This confirms that, because of the unique URL, the CDN is forced to request the image again from the Blob service.
- Windows Azure Learning Note (4) - Updating
- Windows Azure Learning Note (1)
- Windows Azure Learning Note (2)
- Windows Azure Learning Note (3)
- Windows Azure Learning Note (5)
- Self-learning:Overview of Updating a Windows Azure Service
- Need in Windows Azure (Updating)
- Programming Windows Azure Note
- Windows Azure Diagnostics Note
- Windows Azure VM Role Note
- Windows Azure Appfabric ACS Note
- Learning note(4) for windows powershell Tips
- Windows Azure Platform 2nd Edition Note
- Windows Azure Appfabric Service Bus Note
- Self-learning: Windows Azure Storage Analytics Released
- Azure Tools (Updating)
- Learning note(1) for Windows PowerShell Tips
- Learning note(2) for windows powershell Tips
- 查找局域网内的mac地址方法
- 卫视基础知识
- ffmpeg库音频解码示例
- C/C++常见问题( 不断更新)
- js得到屏幕宽高、页面宽高 (window.screen.availHeight)等
- Windows Azure Learning Note (4) - Updating
- 后台服务所应该具备的非业务特性。
- Oracle数据恢复 - Linux / Unix 误删除的文件恢复
- js之ActiveX 控件说明 new ActiveXObject();
- 比较杂的
- Android matrix 控制图片的旋转、缩放、移动
- Configure ADF 11.1.2.1.0 on WebLogic 10.3.5
- DataGridView按列顺序导出Excel
- DB2 实现 ORACLE LIKE 关联