Importing the Azure SQL Server Database
This section describes how to import the data from the source system to the target system for an Azure SQL server database. Perform the following steps to import an Azure SQL server database:
2. Download the
SqlPackage.exe if not already downloaded. You can get more details about the
SqlPackage utility from the
Microsoft page.
4. Import the bacpac file from Azure Storage container to Azure SQL server database by running the following command:
sqlpackage.exe /Action:Import /tsn:tcp:<SampleSQLServer.sample.net>,1433 /tdn:<SampleDatabase> /tu:<SourceUser> /tp:<SourcePassword> /sf:<StorageLocation>\<SampleDatabase>.bacpac