New-AzSqlSyncMember
Membuat Anggota Sinkronisasi Azure SQL Database.
Sintaks
New-AzSqlSyncMember
-Name <String>
-MemberDatabaseType <String>
-MemberServerName <String>
-MemberDatabaseName <String>
-MemberDatabaseCredential <PSCredential>
[-SyncDirection <String>]
[-UsePrivateLinkConnection]
[-SyncMemberAzureDatabaseResourceId <String>]
[-SyncGroupName] <String>
[-ServerName] <String>
[-DatabaseName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
New-AzSqlSyncMember
-Name <String>
-MemberDatabaseType <String>
-SyncAgentResourceGroupName <String>
-SyncAgentServerName <String>
-SyncAgentName <String>
-SqlServerDatabaseId <String>
[-SyncDirection <String>]
[-UsePrivateLinkConnection]
[-SyncMemberAzureDatabaseResourceId <String>]
[-SyncGroupName] <String>
[-ServerName] <String>
[-DatabaseName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
New-AzSqlSyncMember
-Name <String>
-MemberDatabaseType <String>
-SqlServerDatabaseId <String>
-SyncAgentResourceID <String>
[-SyncDirection <String>]
[-UsePrivateLinkConnection]
[-SyncMemberAzureDatabaseResourceId <String>]
[-SyncGroupName] <String>
[-ServerName] <String>
[-DatabaseName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Deskripsi
Cmdlet New-AzSqlSyncMember membuat Anggota Sinkronisasi Azure SQL Database.
Contoh
Contoh 1: Buat anggota sinkronisasi untuk database Azure SQL.
$credential = Get-Credential
New-AzSqlSyncMember -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -SyncGroupName "SyncGroup01" -Name "SyncMember01" -SyncDirection "OneWayMemberToHub" `
-MemberDatabaseType "AzureSqlDatabase" -MemberServerName "memberServer01.full.dns.name" -MemberDatabaseName "memberDatabase01" -MemberDatabaseCredential $credential | Format-List
ResourceId : subscriptions/{subscriptionId}/resourceGroups/{ResourceGroup01}/servers/{Server01}/databases/{Database01}/syncGroups/{SyncGroup01}/syncMembers/{SyncMember01}
ResourceGroupName : ResourceGroup01
ServerName : Server01
DatabaseName : Database01
SyncGroupName : SyncGroup01
SyncMemberName : SyncMember01
SyncDirection : OneWayMemberToHub
MemberDatabaseType: : AzureSqlDatabase
SyncAgentId :
SqlServerDatabaseId :
MemberServerName : memberServer01.full.dns.name
MemberDatabaseName : memberDatabase01
MemberDatabaseUserName : myAccount
MemberDatabasePassword :
SyncState : UnProvisioned
Perintah ini membuat anggota sinkronisasi untuk database Azure SQL.
Contoh 2: Membuat anggota sinkronisasi untuk database SQL Server lokal
$credential = Get-Credential
New-AzSqlSyncMember -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -SyncGroupName "SyncGroup01" -Name "SyncMember01" -SyncDirection "OneWayMemberToHub" `
-MemberDatabaseType "SqlServerDatabase" -SqlServerDatabaseId "dbId" -syncAgentResourceGroupName "syncAgentResourceGroupName" -syncAgentServerName "syncAgentServerName" `
-syncAgentDatabaseName "syncAgentDatabaseName" -syncAgentName "agentName" | Format-List
ResourceId : /subscriptions/{subscriptionId}/resourceGroups/{ResourceGroup01}/servers/{Server01}/databases/{Database01}/syncGroups/{SyncGroup01}/syncMembers/{SyncMember01}
ResourceGroupName : ResourceGroup01
ServerName : Server01
DatabaseName : Database01
SyncGroupName : SyncGroup01
SyncMemberName : SyncMember01
SyncDirection : OneWayMemberToHub
MemberDatabaseType: : AzureSqlDatabase
SyncAgentId : /subscriptions/{subscriptionId}/resourceGroups/{syncAgentResourceGroupName}/servers/{syncAgentServerName}/syncAgents/{syncAgentId}
SqlServerDatabaseId : dbId
MemberServerName :
MemberDatabaseName :
MemberDatabaseUserName : myAccount
MemberDatabasePassword :
SyncState : UnProvisioned
Perintah ini membuat anggota sinkronisasi untuk database SQL lokal.
Parameter
-Confirm
Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.
Jenis: | SwitchParameter |
Alias: | cf |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-DatabaseName
Nama Azure SQL Database.
Jenis: | String |
Position: | 2 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-DefaultProfile
Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan azure
Jenis: | IAzureContextContainer |
Alias: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-MemberDatabaseCredential
Kredensial (nama pengguna dan kata sandi) dari Azure SQL Database.
Jenis: | PSCredential |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-MemberDatabaseName
Nama Azure SQL Database dari database anggota.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-MemberDatabaseType
Jenis database database anggota.
Jenis: | String |
Nilai yang diterima: | SqlServerDatabase, AzureSqlDatabase |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-MemberServerName
Nama Azure SQL Server dari database anggota.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-Name
Nama anggota sinkronisasi.
Jenis: | String |
Alias: | SyncMemberName |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-ResourceGroupName
Nama grup sumber daya.
Jenis: | String |
Position: | 0 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-ServerName
Nama Azure SQL Server.
Jenis: | String |
Position: | 1 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-SqlServerDatabaseId
Id database server SQL yang disambungkan oleh agen sinkronisasi.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-SyncAgentName
Nama agen sinkronisasi.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-SyncAgentResourceGroupName
Nama grup sumber daya tempat agen sinkronisasi berada.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-SyncAgentResourceID
ID sumber daya agen sinkronisasi.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-SyncAgentServerName
Nama Azure SQL Server tempat agen sinkronisasi berada.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | False |
Terima karakter wildcard: | False |
-SyncDirection
Arah sinkronisasi anggota sinkronisasi ini.
Jenis: | String |
Nilai yang diterima: | Bidirectional, OneWayMemberToHub, OneWayHubToMember |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-SyncGroupName
Nama grup sinkronisasi.
Jenis: | String |
Position: | 3 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-SyncMemberAzureDatabaseResourceId
ID sumber daya untuk database anggota sinkronisasi, digunakan jika UsePrivateLinkConnection diatur ke true.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-UsePrivateLinkConnection
Gunakan koneksi tautan privat saat menyambungkan ke anggota sinkronisasi ini.
Jenis: | SwitchParameter |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-WhatIf
Menunjukkan apa yang akan terjadi jika cmdlet berjalan. Cmdlet tidak dijalankan.
Jenis: | SwitchParameter |
Alias: | wi |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |