SubmitAttachDatabase Method

Attaches a Touchstone® Exposure or Results Database to a SQL Database Server.

Syntax

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

Public Function SubmitAttachDatabase( _
   ByVal request As SubmitAttachDatabaseRequest _
) As SubmitAttachDatabaseResponse

Dim instance As DataSourceManagementServiceClient
Dim request As SubmitAttachDatabaseRequest
Dim value As SubmitAttachDatabaseResponse
 
value = instance.SubmitAttachDatabase(request)

public SubmitAttachDatabaseResponse SubmitAttachDatabase( 
   SubmitAttachDatabaseRequest request
)

Parameters

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

Return Value

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

Remarks

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 attach a Touchstone Database to a SQL Database Server using the SubmitAttachDatabase() method:

using System;
using AIR.Services.Common.Data;
using AIR.Services.DataSourceManagement.Api;
using AIR.Services.DataSourceManagement.Data;
            
class SnippetSubmitAttachDatabaseRequest
{
    private static void AttachDatabase(int businessUnitSid, int sqlInstanceSid, string dbServerName, string dbName, string mdfFilePath, string ldfFilePath)
    {
        DataSourceManagementServiceClient dsClient = new DataSourceManagementServiceClient();
        SubmitAttachDatabaseRequest request = new SubmitAttachDatabaseRequest();
        request.BusinessUnitSid = businessUnitSid;
        request.SqlInstanceSid = sqlInstanceSid;
        request.Database = new Database()
        {
            DataServerName = dbServerName,
            Name = dbName,
            MdfFilePath = mdfFilePath,
            LdfFilePath = ldfFilePath
        };
        SubmitAttachDatabaseResponse response = dsClient.SubmitAttachDatabase(request);
        if (response.Status.Code == StatusCode.Success)
        {
            Console.WriteLine("Submitted successfully to HPC with Activity ID: " + response.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