Get-AzureRMSqlDatabase how to rename a database

[eriksteinebach]

Cmdlet(s)

Get-AzureSqlDatabase
Get-AzureRMSqlDatabase

PowerShell Version

5.1.14986.1000

OS Version

10.0.14986.1000

Description

Get-AzureSqlDatabase contains an argument -NewDatabaseName to rename a database. I am looking for a way to do the same with the Get-AzureRMSqlDatabase command (or any other command within the AzureRM powershell commands). But I cannot find a way to do it? I must be missing something, but I have been googling for 2 hours and I can't find any example.

I want to do this:
Set-AzureSqlDatabase -ServerName $ServerName -DatabaseName $DatabaseName -NewDatabaseName $NewDatabaseName

But than with AzureRM commands, something like:
Get-AzureRMSqlDatabase -ResourceGroupName $ResourceGroupName -ServerName $SeverName -DatabaseName $DatabaseName -????

Edit: Just to clarify, I understand there are other ways to change the database name via powershell, but I can not imagine there is no way in the AzureRM commands. I want to keep my scripts as clean as possible

[cormacpayne]

@akromm Hey Adam, would you mind taking a look at this issue?

[akromm-zz]

@eriksteinebach Unfortunately we do not yet support renaming databases via ARM. Work to enable this is in progress but I do not have an ETA at the moment.

[yatesy]

Hi guys, any update on this as I want to use the ARM version of rename as well.

[akromm-zz]

@yatesy Unfortunately the work is still in progress. There are a number of back-end changes that we are working on to enable this. As a temporary work around you will need to use TSQL.

[rfcdejong]

I also had to apply the work around. Beside that will it also be possible to check if a database exists without listing all databases?

[akromm-zz]

@rfcdejong Through powershell you can use the -DatabaseName parameter in the Get-AzureRmSqlDatabase cmdlet. In TSQL I believe you should be able to use a WHERE clause to filter.

[rfcdejong]

Haha yes ofcourse, but would be nice to use the generated SqlManagementClient in C# .NET instead of using a release environment definition to pass a variable with the master password into the application during release.

[akromm-zz]

@rfcdejong @jaredmoo jaredmoo/azure-sdk-for-net@510cff3

[mpack7225]

Any estimate on when will the commandlets be updated for this? Looking for a Set-AzureRMSqlDatabase, similar to the old Set-AzureSqlDatabase that let's you change the name of the database.

[jaredmoo]

It will be in the next release. #5009

[cormacpayne]

This has been resolved.

[rfcdejong]

I have it working using the Microsoft.Azure.Management.Sql 1.11.0-preview NuGet package, but it is kinda difficult to call, why isn't it simply a parameter with newName?

This is my code what I have to write now with the new function.
It seems to require a ResourceMoveDefinition.

        public async Task RenameAsync(string resourceGroupName, string serverName, string databaseName, string newName)
        {
            EnsureManagementClients();
            
            var newDefinition = new ResourceMoveDefinition
            {
                Id = $"/subscriptions/{_sqlMgmtClient.SubscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{newName}"
            };

            await _sqlMgmtClient.Databases.RenameAsync(resourceGroupName, serverName, databaseName, newDefinition);
        }

[jaredmoo]

Thanks for the feedback! Since your comment is azure-sdk-for-net, I have opened an issue over there and I am investigating how to fix this.

[jaredmoo]

@rfcdejong the change has been merged into Microsoft.Azure.Management.Sql and will be in the next release (1.13). Thanks again!