Unable to update COMPATIBILITY_LEVEL of database in ssms 2016

Question

While deploying the database on the Azure server, I get an error as:

The database compatibility level '15' is not within the supported range of 80 to 130. (Microsoft.SqlServer.Dac)

I tried updating the COMPATIBILITY_LEVEL by the below command:

ALTER DATABASE  [database_name]
SET COMPATIBILITY_LEVEL = 100;  
GO

But when I check the compatibility mode through the "Properties" of the database, I see a blank tab and I can't select any value from the dropdown.

Below is the information of SQL server management studio I've installed on my machine:

Can anyone please suggest what steps should I follow to update the compatibility level of any of the databases while using this version of SSMS?

As mentioned in one of the comments, below is the output for command

SELECT SERVERPROPERTY('ProductVersion') 

Also, below is the output for command

SELECT name, compatibility_level FROM sys.databases;

While compatibility level of databases shows 100 and above in the result, not sure why I'm receiving the error. Would appreciate any suggestions.

Answer 1

The error message seems to be incorrect because:

1. the version numbers in Azure SQL aren't relatable to those in SQL Server, and
2. no single version of SQL Server covers levels from 80 through 130 (SQL Server 2000 through 2016).

As per ALTER DATABASE (Transact-SQL) Compatibility Level

Important

The database engine version numbers for SQL Server and Azure SQL Database are not comparable with each other, and rather are internal build numbers for these separate products. The database engine for Azure SQL Database is based on the same code base as the SQL Server database engine. Most importantly, the database engine in Azure SQL Database always has the newest SQL database engine bits. Version 12 of Azure SQL Database is newer than version 15 of SQL Server.