SubmitCreateDatabase Method

Creates a new Touchstone® Database.

Syntax

Visual Basic (Declaration)
Visual Basic (Usage)
C#

Public Function SubmitCreateDatabase( _
   ByVal request As SubmitCreateDatabaseRequest _
) As SubmitCreateDatabaseResponse

Dim instance As DataSourceManagementServiceClient
Dim request As SubmitCreateDatabaseRequest
Dim value As SubmitCreateDatabaseResponse
 
value = instance.SubmitCreateDatabase(request)

public SubmitCreateDatabaseResponse SubmitCreateDatabase( 
   SubmitCreateDatabaseRequest request
)

Parameters

request: Contains a SubmitCreateDatabaseRequest that identifies the properties of the Database that you want to create, along with the associated Touchstone-generated Business Unit SID and SQL Instance SID.

Return Value

A SubmitCreateDatabaseResponse containing the Activity SID that uniquely identifies the asynchronous web service call that you made to create the specified Database.

Remarks

The Database Name cannot include the following special characters: `-=~!@#$%^&_+{};',

To find the Business Unit SID to pass into this method, call the GetBusinessUnits() method.

To find the SQL Instance SID to pass into this method, call the GetSqlInstances() method.

Example

The following example shows how to create a Touchstone Database using the SubmitCreateDatabase() method:

using System;
using AIR.Services.Common.Data;
using AIR.Services.DataSourceManagement.Api;
using AIR.Services.DataSourceManagement.Data;
            
class SnippetSubmitCreateDatabaseRequest
{
    private static void CreateDatabase(int businessUnitSid, int sqlInstanceSid, string dbServerName, 
        string databaseType, string dbName, string mdfFilePath)
    {
        DataSourceManagementServiceClient dsClient = new DataSourceManagementServiceClient();
        SubmitCreateDatabaseRequest createRequest = new SubmitCreateDatabaseRequest();
        createRequest.BusinessUnitSid = businessUnitSid;
        createRequest.SqlInstanceSid = sqlInstanceSid;
        createRequest.Database = new Database()
        {
            DataServerName = dbServerName,
            Name = dbName,
            Description = "Created by API",
            Type = databaseType.ToUpper(),
            MdfFilePath = mdfFilePath,
            Growth = 1048576,
            GrowthUnit = "KB"
        };
            
        SubmitCreateDatabaseResponse createResponse = dsClient.SubmitCreateDatabase(createRequest);
        if (createResponse.Status.Code == StatusCode.Success)
        {
            Console.WriteLine("Submitted successfully to HPC with Activity ID: " + createResponse.ActivitySid);
        }
    }
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DataSourceManagementServiceClient Class
DataSourceManagementServiceClient Members