0 0

Migrate SQL database to Azure

Export:

SSMS > Connect to local SQL
Right click DATABASE > Tasks > Export Data-tier application
Browse > X:\DATABASE.bacpac > Next > Finish

Import:

SSMS > Connect to Azure SQL
Right click Databases > Import Data-tier application
Browse > X:\DATABASE.bacpac > Next
Edition: Standard
Maximum size: 300
Service Objective: S7