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