Wednesday, February 22, 2023

Database import failure from SANDBOX to DEV VM in D365FO

 Error: " Changes to connection setting default values were incorporated in a recent release. Error importing database: Could not import package."

Command:

SqlPackage.exe /a:import /sf:J:\MSSQL_BACKUP\AXDBSIT_19122022_backup.bacpac /tsn:localhost /tdn:AxDB_SIT_19122022 /p:CommandTimeout=1200

CauseConnection Security Improvements in SqlPackage 161 - Microsoft Community Hub 

Fix (Solution):

SqlPackage.exe /a:import /sf:J:\MSSQL_BACKUP\AXDBSIT_19122022_backup.bacpac /tsn:localhost /tdn:AxDB_SIT_19122022 /p:CommandTimeout=1200 /TargetEncryptConnection:False

No comments:

Post a Comment

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...