Exporting the Azure SQL Server Source Database
This section describes how to export data of the source system for Azure SQL server database. This data can be imported into the database on the target system for an Azure SQL server database. Perform the following steps to export an Azure SQL server database:
1. Create the storage account and container in Azure.
2. Download the SqlPackage.exe from the Microsoft page. You can get more details about the SqlPackage utility from this Microsoft page.
3. Export the source database using SQLpackage.exe by running the following command:
SqlPackage.exe /Action:Export /SourceServerName:<SampleSQLServer.sample.net>,1433
/SourceDatabaseName:<SampleDatabase>
/SourceUser:<SourceUser> /SourcePassword:<SourcePassword>
/TargetFile:"<StorageLocation>\<SampleDatabase>.bacpac”
¿Fue esto útil?