In this blog we will see how to migrate the SQL Server database to Azure SQL Server. The Import and Export Wizard is a simple way to copy data using bacpac file.
Export to bacpac file in SQL Server Management Studio (SSMS)
- Open and connect database file in SQL Server Management Studio (SSMS)
2. To export a database file, right click on the name of the database. In the context menu, select Tasks > Export Data-tier Application.
3. The option will open the wizard. Click Next> Introduction page and go to the Export Settings
4. Export Settings are requested to the location to save the bacpac file
- You can save it to the local disk or Azure Storage account. Since you don’t have an Azure Storage account, you’ll save the bacpac file and file name to the local disk.
- If you want to migrate a full database, select all the objects. After the location is selected, click Next.
5. The current Summary page looks like below. You can verify and confirm the Settings here. After all information is verified, click Finish.
6. It starts the exporting now. Click the Close button to exit the bacpac Export wizard.
Import a bacpac file to Azure SQL
To create an SQL Azure database form a bacpac file in SSMS, connect to the SQL Azure Server.