Canarys | IT Services


Migrate SQL Server Database To Azure SQL Server


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)

  1. 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