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