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”