2

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

Improve this question

1 Answer 1

Reset to default
3
Answer recommended by Microsoft Azure Collective

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

what a wonderful tool...not sure how I haven't run into it sooner! thanks!!
I am glad you have that user experience with the tool.
Its a fine tool, but is extremely slow.
@GerardoBuenrostroGonzález Try Azure Data Studio also. learn.microsoft.com/en-us/sql/azure-data-studio/extensions/…

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.