WIP/Restore-DatabaseByScriptOut.ps1

function Restore-DatabaseByScriptOut
{
    [CmdletBinding()]
    param(
        [Parameter(Mandatory=$true)] [string]$SourceSqlInstance,
        [Parameter(Mandatory=$true)] [string]$SourceDatabase,
        [Parameter(Mandatory=$true)] [string]$DestinationSqlInstance,
        [Parameter(Mandatory=$true)] [string]$DestinationDatabase,
        [Parameter(Mandatory=$true)] [string]$WorkingDirectory,
        [Parameter(Mandatory=$false)][switch]$CreateDatabaseShell
    )

    if($CreateDatabaseShell) 
    {
        Write-Verbose "Logic to create Database Shell begins here..";

        $d_srv = new-Object Microsoft.SqlServer.Management.Smo.Server("$DestinationSqlInstance")  
        $d_db = New-Object Microsoft.SqlServer.Management.Smo.Database($d_srv, "$DestinationDatabase")  
        $d_db.Create()  
        if($d_db.CreateDate) {
            Write-Verbose "Database [$DestinationSqlInstance].[$DestinationDatabase] shell is created..";
        }

    }else {
        Write-Verbose "Checking to make sure database [$DestinationSqlInstance].[$DestinationDatabase] shell already exists";
    }

    $SourceSqlInstance_p = $SourceSqlInstance;
    if($SourceSqlInstance -notcontains '\') {$SourceSqlInstance_p += '\MSSQLSERVER'}

    $DestinationSqlInstance_p = $DestinationSqlInstance;
    if($DestinationSqlInstance -notcontains '\') {$DestinationSqlInstance_p += '\MSSQLSERVER'}
}

Invoke-Sqlcmd -ServerInstance SqlProd1 -Query 'drop database Global';

Restore-DatabaseByScriptOut -SourceSqlInstance SqlProd1 -SourceDatabase Global `
                            -DestinationSqlInstance SqlProd1 -DestinationDatabase Global `
                            -WorkingDirectory c:\temp\migration -CreateDatabaseShell `
                            -Verbose