Rename-SQLDatabase powershell

gistfile1.ps1

Function Rename-SQLDatabase {
  param (
  		[string] $ServerName,
  		[string] $SourceDb,
  		[string] $DestDb
)

	$connection = New-Object System.Data.SqlClient.SqlConnection
	$command = New-Object System.Data.SqlClient.SqlCommand

	$connection.ConnectionString = "Server=$ServerName;Integrated Security=True;"
 
	$command.CommandText = "ALTER DATABASE [$SourceDb] SET OFFLINE WITH ROLLBACK IMMEDIATE;ALTER DATABASE [$SourceDb] SET ONLINE;EXEC sp_renamedb [$SourceDb], [$DestDb];"
	$command.Connection = $connection

	$command.Connection.Open();
	$command.ExecuteNonQuery();
	$command.Connection.Close();
}