/// <summary>
/// Import DAC from Windows Azure blob storage.
/// </summary>
/// <param name='serverName'>
/// The name of the server being imported to.
/// </param>
/// <param name='parameters'>
/// Import parameters.
/// </param>
/// <param name='cancellationToken'>
/// Cancellation token.
/// </param>
/// <returns>
/// Response for an DAC Import/Export request.
/// </returns>
public async Task <DacImportExportResponse> ImportAsync(string serverName, DacImportParameters parameters, CancellationToken cancellationToken)
{
// Validate
if (serverName == null)
{
throw new ArgumentNullException("serverName");
}
if (parameters != null)
{
if (parameters.BlobCredentials != null)
{
if (parameters.BlobCredentials.StorageAccessKey == null)
{
throw new ArgumentNullException("parameters.BlobCredentials.StorageAccessKey");
}
if (parameters.BlobCredentials.Uri == null)
{
throw new ArgumentNullException("parameters.BlobCredentials.Uri");
}
}
if (parameters.ConnectionInfo != null)
{
if (parameters.ConnectionInfo.DatabaseName == null)
{
throw new ArgumentNullException("parameters.ConnectionInfo.DatabaseName");
}
if (parameters.ConnectionInfo.Password == null)
{
throw new ArgumentNullException("parameters.ConnectionInfo.Password");
}
if (parameters.ConnectionInfo.ServerName == null)
{
throw new ArgumentNullException("parameters.ConnectionInfo.ServerName");
}
if (parameters.ConnectionInfo.UserName == null)
{
throw new ArgumentNullException("parameters.ConnectionInfo.UserName");
}
}
}
// Tracing
bool shouldTrace = CloudContext.Configuration.Tracing.IsEnabled;
string invocationId = null;
if (shouldTrace)
{
invocationId = Tracing.NextInvocationId.ToString();
Dictionary <string, object> tracingParameters = new Dictionary <string, object>();
tracingParameters.Add("serverName", serverName);
tracingParameters.Add("parameters", parameters);
Tracing.Enter(invocationId, this, "ImportAsync", tracingParameters);
}
// Construct URL
string url = new Uri(this.Client.BaseUri, "/").ToString() + this.Client.Credentials.SubscriptionId + "/services/sqlservers/servers/" + serverName + "/DacOperations/Import";
// Create HTTP transport objects
HttpRequestMessage httpRequest = null;
try
{
httpRequest = new HttpRequestMessage();
httpRequest.Method = HttpMethod.Post;
httpRequest.RequestUri = new Uri(url);
// Set Headers
httpRequest.Headers.Add("x-ms-version", "2012-03-01");
// Set Credentials
cancellationToken.ThrowIfCancellationRequested();
await this.Client.Credentials.ProcessHttpRequestAsync(httpRequest, cancellationToken).ConfigureAwait(false);
// Serialize Request
string requestContent = null;
XDocument requestDoc = new XDocument();
if (parameters != null)
{
XElement importInputElement = new XElement(XName.Get("ImportInput", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
requestDoc.Add(importInputElement);
if (parameters.AzureEdition != null)
{
XElement azureEditionElement = new XElement(XName.Get("AzureEdition", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
azureEditionElement.Value = parameters.AzureEdition;
importInputElement.Add(azureEditionElement);
}
if (parameters.BlobCredentials != null)
{
XElement blobCredentialsElement = new XElement(XName.Get("BlobCredentials", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
importInputElement.Add(blobCredentialsElement);
XAttribute typeAttribute = new XAttribute(XName.Get("type", "http://www.w3.org/2001/XMLSchema-instance"), "");
typeAttribute.Value = "BlobStorageAccessKeyCredentials";
blobCredentialsElement.Add(typeAttribute);
XElement uriElement = new XElement(XName.Get("Uri", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
uriElement.Value = parameters.BlobCredentials.Uri.ToString();
blobCredentialsElement.Add(uriElement);
XElement storageAccessKeyElement = new XElement(XName.Get("StorageAccessKey", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
storageAccessKeyElement.Value = parameters.BlobCredentials.StorageAccessKey;
blobCredentialsElement.Add(storageAccessKeyElement);
}
if (parameters.ConnectionInfo != null)
{
XElement connectionInfoElement = new XElement(XName.Get("ConnectionInfo", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
importInputElement.Add(connectionInfoElement);
XElement databaseNameElement = new XElement(XName.Get("DatabaseName", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
databaseNameElement.Value = parameters.ConnectionInfo.DatabaseName;
connectionInfoElement.Add(databaseNameElement);
XElement passwordElement = new XElement(XName.Get("Password", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
passwordElement.Value = parameters.ConnectionInfo.Password;
connectionInfoElement.Add(passwordElement);
XElement serverNameElement = new XElement(XName.Get("ServerName", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
serverNameElement.Value = parameters.ConnectionInfo.ServerName;
connectionInfoElement.Add(serverNameElement);
XElement userNameElement = new XElement(XName.Get("UserName", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
userNameElement.Value = parameters.ConnectionInfo.UserName;
connectionInfoElement.Add(userNameElement);
}
XElement databaseSizeInGBElement = new XElement(XName.Get("DatabaseSizeInGB", "http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.Management.Dac.ServiceTypes"));
databaseSizeInGBElement.Value = parameters.DatabaseSizeInGB.ToString();
importInputElement.Add(databaseSizeInGBElement);
}
requestContent = requestDoc.ToString();
httpRequest.Content = new StringContent(requestContent, Encoding.UTF8);
httpRequest.Content.Headers.ContentType = new MediaTypeHeaderValue("application/xml");
// Send Request
HttpResponseMessage httpResponse = null;
try
{
if (shouldTrace)
{
Tracing.SendRequest(invocationId, httpRequest);
}
cancellationToken.ThrowIfCancellationRequested();
httpResponse = await this.Client.HttpClient.SendAsync(httpRequest, cancellationToken).ConfigureAwait(false);
if (shouldTrace)
{
Tracing.ReceiveResponse(invocationId, httpResponse);
}
HttpStatusCode statusCode = httpResponse.StatusCode;
if (statusCode != HttpStatusCode.OK)
{
cancellationToken.ThrowIfCancellationRequested();
CloudException ex = CloudException.Create(httpRequest, requestContent, httpResponse, await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false), CloudExceptionType.Xml);
if (shouldTrace)
{
Tracing.Error(invocationId, ex);
}
throw ex;
}
// Create Result
DacImportExportResponse result = null;
// Deserialize Response
cancellationToken.ThrowIfCancellationRequested();
string responseContent = await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
result = new DacImportExportResponse();
XDocument responseDoc = XDocument.Parse(responseContent);
XElement guidElement = responseDoc.Element(XName.Get("guid", "http://schemas.microsoft.com/2003/10/Serialization/"));
if (guidElement != null)
{
result.Guid = guidElement.Value;
}
result.StatusCode = statusCode;
if (httpResponse.Headers.Contains("x-ms-request-id"))
{
result.RequestId = httpResponse.Headers.GetValues("x-ms-request-id").FirstOrDefault();
}
if (shouldTrace)
{
Tracing.Exit(invocationId, result);
}
return(result);
}
finally
{
if (httpResponse != null)
{
httpResponse.Dispose();
}
}
}
finally
{
if (httpRequest != null)
{
httpRequest.Dispose();
}
}
}
/// <summary>
/// Initiates an Import of a DACPAC file from Azure Blob Storage into a
/// Azure SQL Database.
/// </summary>
/// <param name='operations'>
/// Reference to the
/// Microsoft.WindowsAzure.Management.Sql.IDacOperations.
/// </param>
/// <param name='serverName'>
/// Required. The name of the Azure SQL Database Server into which the
/// database is being imported.
/// </param>
/// <param name='parameters'>
/// Optional. The parameters needed to initiated the Import request.
/// </param>
/// <returns>
/// Represents the response that the service returns once an import or
/// export operation has been initiated.
/// </returns>
public static DacImportExportResponse Import(this IDacOperations operations, string serverName, DacImportParameters parameters)
{
return(Task.Factory.StartNew((object s) =>
{
return ((IDacOperations)s).ImportAsync(serverName, parameters);
}
, operations, CancellationToken.None, TaskCreationOptions.None, TaskScheduler.Default).Unwrap().GetAwaiter().GetResult());
}
/// <summary>
/// Initiates an Import of a DACPAC file from Azure Blob Storage into a
/// Azure SQL Database.
/// </summary>
/// <param name='operations'>
/// Reference to the
/// Microsoft.WindowsAzure.Management.Sql.IDacOperations.
/// </param>
/// <param name='serverName'>
/// Required. The name of the Azure SQL Database Server into which the
/// database is being imported.
/// </param>
/// <param name='parameters'>
/// Optional. The parameters needed to initiated the Import request.
/// </param>
/// <returns>
/// Represents the response that the service returns once an import or
/// export operation has been initiated.
/// </returns>
public static Task <DacImportExportResponse> ImportAsync(this IDacOperations operations, string serverName, DacImportParameters parameters)
{
return(operations.ImportAsync(serverName, parameters, CancellationToken.None));
}
/// <summary>
/// Import DAC from Windows Azure blob storage.
/// </summary>
/// <param name='operations'>
/// Reference to the
/// Microsoft.WindowsAzure.Management.Sql.IDacOperations.
/// </param>
/// <param name='serverName'>
/// The name of the server being imported to.
/// </param>
/// <param name='parameters'>
/// Import parameters.
/// </param>
/// <returns>
/// Response for an DAC Import/Export request.
/// </returns>
public static DacImportExportResponse Import(this IDacOperations operations, string serverName, DacImportParameters parameters)
{
try
{
return(operations.ImportAsync(serverName, parameters).Result);
}
catch (AggregateException ex)
{
if (ex.InnerExceptions.Count > 1)
{
throw;
}
else
{
throw ex.InnerException;
}
}
}
