attempting to your Invoke-D365FFOAxDBRestoreFromBACPAC.ps1

[eqgithub]

When I run your Invoke-D365FFOAxDBRestoreFromBACPAC.ps1

it throws a error at Switch-D365ActiveDatabase -NewDatabaseName $NewDB -Verbose

upon further digging the bacpac restores but the database is empty of all content which is why it throws the error:

16:11:57][Switch-D365ActiveDatabase] It seems that the new database either doesn't exists, isn't a valid AxDB database or your don't have enough permissions. | Exception calling "ExecuteScalar" with "0" argument(s): "Invalid object name 'dbo.USERINFO'."
Write-PSFMessage : Exception calling "ExecuteScalar" with "0" argument(s): "Invalid object name 'dbo.USERINFO'."
At line:33251 char:9

•     Write-PSFMessage -Level Host -Message $messageString -Excepti ...
  

•     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : NotSpecified: (USE [costco_mfg... ID = 'Admin'
    :String) [Write-PSFMessage], MethodInvocationException
  • FullyQualifiedErrorId : d365fo.tools_Switch-D365ActiveDatabase,PSFramework.Commands.WritePSFMessageCommand