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:
1. Copy the bacpac file exported as described in Exporting the Azure SQL Server Source Database, to Azure Storage account container.
2. Download the SqlPackage.exe if not already downloaded. You can get more details about the SqlPackage utility from the Microsoft page.
3. Create Azure SQL database, if not already created. For more details, see Creating an Azure SQL Database.
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
Было ли это полезно?