Restore Database User Guide
This section contains the steps to restore the azure database into your VM’s 1.1 Latest version of SQL server management studio Install the latest version of SQL Server Management Studio in your local VM: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms Select the highlighed option (NOT the upgrade package): 1.2 Azure Database restore on VM Please follow below steps on your local VM to intiate the restore · Open command prompt with administrative privileges. · Run the following scripts a) cd C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin b) SqlPackage.exe /a:import /sf: C:\Temp\ FAT.bacpac /tsn:localhost /tdn:FATCopy /p:CommandTimeout=1200 Replace D:\ with the path where you saved the bacpac file. · ...