CODEWITHSUNDEEP
sql-serverdatabaseazureazure-sql-database
blizz
blizz

Reputation: 4168

Deploy SQL database to Azure is failing

I am trying to deploy a SQL Server database to Azure. In SSMS, I right click the database and choose Tasks > Deploy Database to Microsoft Azure SQL Database.

This database isn't part of source control or anything, and in the properties, I selected compatibility level 140 (SQL Server 2017).

However, I keep getting the error below when deploying it. What am I doing wrong? I was able to deploy this exact database in the past without issues.

SSMS error

Upvotes: 2

Views: 803

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15628

Please forget about SSMS for migrating databases to Azure SQL Database. Use Microsoft Data Migration Assistant for this task. This tool is the easiest way to migrate to Azure SQL Database. It performs an assessment first, then it migrates your databases to Azure.

Upvotes: 3

Related Questions