"Could not import package.
Waring SQL0: A project which specifiesMicrosoft Azure SQL Database v12 as the target platform may experiencecompatibility issue with SQL Server 2014."Microsoft says it is an known issue but I don't know how to fix the problem.https://social.technet.microsoft.com/Forums/WINDOWS/en-US/5b37d868-3106-4358-b7a6-a50d0890f079/sql-azure-import-of-bacpac-does-not-work-after-upgrade-to-v12?forum=ssdsgetstartedAny idea?
$Q = $('Select * from [{0}].[{1}];' -f $tb.Schema, $tb.Name ) Write-Verbose $('{0} - Reading data from [{1}].[{2}] ;' -f (get-date -Format 'yyyy-MM-dd HH:mm:ss') , $tb.Schema, $tb.Name ) ; $Result = $db.ExecuteWithResults( $q ) $TsCopy = Get-Date Write-DataTable -ServerInstance $TargetSQLServerName -Username $TargetUserName -Password $TargetPwd -Database $TargetDbName -TableName $tb.Name -Schema $tb.Schema -Data $Result.tables[0] -BatchSize 1000 ; $TsCopyEnd = Get-Date $nSec = (New-TimeSpan -Start $TsCopy -End $TsCopyEnd).TotalSeconds ; Write-output $('{0} - Table [{1}].[{2}] exported to [{3}].[{4}] - {5} rows - Time needed {6}' -f (get-date -Format 'yyyy-MM-dd HH:mm:ss'), $tb.Schema, $tb.Name , $tb.Schema, $tb.Name, $Result.tables[0].Rows.Count, (get-date (( Get-Date -day 1 –month 1 -year 1900 -Hour 0 -Minute 0 -Second 0 ).addseconds( $nSec )) -format 'HH:mm:ss.fff') ) ;
