Tuesday, 6 April 2021

AX365 Dev machine import and Export restore a DB .bacpac file from the UAT

 Download the  Get sqlpackage .NET Core for Windows


extract the folder and run the command prompt as an administrator and run the below command


SqlPackage.exe /a:import /sf:D:\Hesham\SafariUATbackup.bacpac /tsn:localhost /tdn:AxDB /p:CommandTimeout=1200  /ttsc:True


Export 


SqlPackage.exe /a:export /TargetFile:H:\BiKeyDB.bacpac /SourceConnectionString:"Server=localhost;Initial Catalog=AxDB;Persist Security Info=False;User ID=sa;Password=sa;MultipleActiveResultSets=False;Encrypt=False;TrustServerCertificate=True;Connection Timeout=1200";




No comments:

Post a Comment