Import Huge Db Sqlserver | SqlPackage.exe

[string]$myBacpac = 'C:\Users\haroun\Downloads\file.bacpac'
[string]$connectionString = 'Data Source=CGDLPT\SQL2019;Initial Catalog=testExp; Integrated Security=true;'
[string]$action = 'Import'

[string[]]$commandParameters = @(
    "/Action:`"$action`""
    "/SourceFile:`"$myBacpac`""
    "/TargetConnectionString:`"$connectionString`""
)

[string]$LatestSqlPackage = Get-Item 'C:\*\Microsoft SQL Server\*\DAC\bin\sqlpackage.exe' | %{get-command $_}| sort version -Descending | select -ExpandProperty source -First 1

if ($LatestSqlPackage) {
    Write-Verbose "Found: $LatestSqlPackage"
    & $LatestSqlPackage $commandParameters
} else {
      Write-Error "Could not find SqlPackage.exe"
}