SyncMember

class SyncMember : KotlinCustomResource

An Azure SQL Database sync member. Uses Azure REST API version 2023-08-01. In version 2.x of the Azure Native provider, it used API version 2021-11-01. Other available API versions: 2015-05-01-preview, 2019-06-01-preview, 2020-02-02-preview, 2020-08-01-preview, 2020-11-01-preview, 2021-02-01-preview, 2021-05-01-preview, 2021-08-01-preview, 2021-11-01, 2021-11-01-preview, 2022-02-01-preview, 2022-05-01-preview, 2022-08-01-preview, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native sql [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.

Example Usage

Create a new sync member

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var syncMember = new AzureNative.Sql.SyncMember("syncMember", new()
{
DatabaseName = "syncgroupcrud-7421",
DatabaseType = AzureNative.Sql.SyncMemberDbType.AzureSqlDatabase,
ResourceGroupName = "syncgroupcrud-65440",
ServerName = "syncgroupcrud-8475",
SyncDirection = AzureNative.Sql.SyncDirection.Bidirectional,
SyncGroupName = "syncgroupcrud-3187",
SyncMemberAzureDatabaseResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/syncgroupcrud-65440/providers/Microsoft.Sql/servers/syncgroupcrud-8475/databases/syncgroupcrud-4328",
SyncMemberName = "syncmembercrud-4879",
UsePrivateLinkConnection = true,
UserName = "myUser",
});
});
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v3"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewSyncMember(ctx, "syncMember", &sql.SyncMemberArgs{
DatabaseName: pulumi.String("syncgroupcrud-7421"),
DatabaseType: pulumi.String(sql.SyncMemberDbTypeAzureSqlDatabase),
ResourceGroupName: pulumi.String("syncgroupcrud-65440"),
ServerName: pulumi.String("syncgroupcrud-8475"),
SyncDirection: pulumi.String(sql.SyncDirectionBidirectional),
SyncGroupName: pulumi.String("syncgroupcrud-3187"),
SyncMemberAzureDatabaseResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/syncgroupcrud-65440/providers/Microsoft.Sql/servers/syncgroupcrud-8475/databases/syncgroupcrud-4328"),
SyncMemberName: pulumi.String("syncmembercrud-4879"),
UsePrivateLinkConnection: pulumi.Bool(true),
UserName: pulumi.String("myUser"),
})
if err != nil {
return err
}
return nil
})
}
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.SyncMember;
import com.pulumi.azurenative.sql.SyncMemberArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var syncMember = new SyncMember("syncMember", SyncMemberArgs.builder()
.databaseName("syncgroupcrud-7421")
.databaseType("AzureSqlDatabase")
.resourceGroupName("syncgroupcrud-65440")
.serverName("syncgroupcrud-8475")
.syncDirection("Bidirectional")
.syncGroupName("syncgroupcrud-3187")
.syncMemberAzureDatabaseResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/syncgroupcrud-65440/providers/Microsoft.Sql/servers/syncgroupcrud-8475/databases/syncgroupcrud-4328")
.syncMemberName("syncmembercrud-4879")
.usePrivateLinkConnection(true)
.userName("myUser")
.build());
}
}

Update a sync member

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var syncMember = new AzureNative.Sql.SyncMember("syncMember", new()
{
DatabaseName = "syncgroupcrud-7421",
DatabaseType = AzureNative.Sql.SyncMemberDbType.AzureSqlDatabase,
ResourceGroupName = "syncgroupcrud-65440",
ServerName = "syncgroupcrud-8475",
SyncDirection = AzureNative.Sql.SyncDirection.Bidirectional,
SyncGroupName = "syncgroupcrud-3187",
SyncMemberAzureDatabaseResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/syncgroupcrud-65440/providers/Microsoft.Sql/servers/syncgroupcrud-8475/databases/syncgroupcrud-4328",
SyncMemberName = "syncmembercrud-4879",
UsePrivateLinkConnection = true,
UserName = "myUser",
});
});
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v3"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewSyncMember(ctx, "syncMember", &sql.SyncMemberArgs{
DatabaseName: pulumi.String("syncgroupcrud-7421"),
DatabaseType: pulumi.String(sql.SyncMemberDbTypeAzureSqlDatabase),
ResourceGroupName: pulumi.String("syncgroupcrud-65440"),
ServerName: pulumi.String("syncgroupcrud-8475"),
SyncDirection: pulumi.String(sql.SyncDirectionBidirectional),
SyncGroupName: pulumi.String("syncgroupcrud-3187"),
SyncMemberAzureDatabaseResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/syncgroupcrud-65440/providers/Microsoft.Sql/servers/syncgroupcrud-8475/databases/syncgroupcrud-4328"),
SyncMemberName: pulumi.String("syncmembercrud-4879"),
UsePrivateLinkConnection: pulumi.Bool(true),
UserName: pulumi.String("myUser"),
})
if err != nil {
return err
}
return nil
})
}
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.SyncMember;
import com.pulumi.azurenative.sql.SyncMemberArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var syncMember = new SyncMember("syncMember", SyncMemberArgs.builder()
.databaseName("syncgroupcrud-7421")
.databaseType("AzureSqlDatabase")
.resourceGroupName("syncgroupcrud-65440")
.serverName("syncgroupcrud-8475")
.syncDirection("Bidirectional")
.syncGroupName("syncgroupcrud-3187")
.syncMemberAzureDatabaseResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/syncgroupcrud-65440/providers/Microsoft.Sql/servers/syncgroupcrud-8475/databases/syncgroupcrud-4328")
.syncMemberName("syncmembercrud-4879")
.usePrivateLinkConnection(true)
.userName("myUser")
.build());
}
}

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sql:SyncMember syncmembercrud-4879 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/syncGroups/{syncGroupName}/syncMembers/{syncMemberName}

Properties

Link copied to clipboard
val azureApiVersion: Output<String>

The Azure API version of the resource.

Link copied to clipboard
val databaseName: Output<String>?

Database name of the member database in the sync member.

Link copied to clipboard
val databaseType: Output<String>?

Database type of the sync member.

Link copied to clipboard
val id: Output<String>
Link copied to clipboard
val name: Output<String>

Resource name.

Link copied to clipboard

Private endpoint name of the sync member if use private link connection is enabled, for sync members in Azure.

Link copied to clipboard
val pulumiChildResources: Set<KotlinResource>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
val serverName: Output<String>?

Server name of the member database in the sync member

Link copied to clipboard

SQL Server database id of the sync member.

Link copied to clipboard
val syncAgentId: Output<String>?

ARM resource id of the sync agent in the sync member.

Link copied to clipboard
val syncDirection: Output<String>?

Sync direction of the sync member.

Link copied to clipboard

ARM resource id of the sync member logical database, for sync members in Azure.

Link copied to clipboard
val syncState: Output<String>

Sync state of the sync member.

Link copied to clipboard
val type: Output<String>

Resource type.

Link copied to clipboard
val urn: Output<String>
Link copied to clipboard

Whether to use private link connection.

Link copied to clipboard
val userName: Output<String>?

User name of the member database in the sync member.