New-AzureRmSqlDatabaseCopy
Syntax
New-AzureRmSqlDatabaseCopy
[-ResourceGroupName] <String>
[-ServerName] <String>
[-DatabaseName] <String>
-CopyDatabaseName <String>
[-CopyResourceGroupName <String>]
[-CopyServerName <String>]
[-ElasticPoolName <String>]
[-ServiceObjectiveName <String>]
[-Tags <Hashtable>]
[-Confirm]
[-WhatIf]
[<CommonParameters>]
Description
The New-AzureRmSqlDatabaseCopy cmdlet creates a copy of an Azure SQL Database that uses the snapshot of the data at the current time. Use this cmdlet instead of the Start-AzureSqlDatabaseCopy cmdlet to create a one-time database copy. This cmdlet returns the Database object of the copy.
Note: Use the New-AzureRmSqlDatabaseSecondary cmdlet to configure geo-replication for a database.
This cmdlet is also supported by the SQL Server Stretch Database service on Azure.
Examples
1:
Required Parameters
Specifies the name of the SQL Database copy.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the name of the SQL Database to copy.
| Type: | String |
| Position: | 2 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
Specifies the name of the Resource Group to which this cmdlet assigns the copied database.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
Specifies the name of the SQL Server that contains the database to copy.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Accept pipeline input: | True (ByPropertyName) |
| Accept wildcard characters: | False |
Optional Parameters
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the name of the Azure Resource Group in which to assign the copy.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the name of the SQL Server which hosts the copy.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the name of the elastic pool in which to assign the copy.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the name of the service objective to assign to the copy.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the Key-value pairs in the form of a hash table to associate with the Azure SQL Database copy. For example:
@{key0="value0";key1=$null;key2="value2"}
| Type: | Hashtable |
| Aliases: | Tag |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Outputs
Microsoft.Azure.Commands.Sql.Replication.Model.AzureSqlDatabaseCopyModel
This cmdlet returns a Database object that represents the copied database.