December 16, 2024

Error while converting .bak file to backpac

Hi Folks, 

I have to restore the Sandbox DB to dev box and was trying SqlPackage utility for the same, 
I Tried with below command, 

SqlPackage.exe /a:export /ssn:localhost /sdn:AxDB.bak /tf:J:\Capgemini\AxDB.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false /SourceTrustServerCertificate:True

But Got error as below

Can you please try below ways


Option 1: (Remove extension from source database)
SqlPackage.exe /a:export /ssn:localhost /sdn:AxDB /tf:J:\theaxapta\AxDB.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false /SourceTrustServerCertificate:True

 

Option 2: (Along with that use user name and password)
SqlPackage.exe /a:export /ssn:localhost /sdn:AxDB /su:axdbadmin /sp:XXXX /tf:J:\Capgemini\AxDB.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false /SourceTrustServerCertificate:True

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta