I found this sentence "After you restore an earlier version database to SQL Server 2019 (15.x), the database is automatically upgraded." from MS official documents.
However after restroration from backup, I looked into SSMS on the database option tab
and I realized that the compatibility information is not available.
Then I started searching on the internet and finally I got the query below which showed
result as 110 which is sql server version 2008.
SELECT compatibility_level FROM sys.databases WHEREname ='mydatabase'
Was upgrade done? or Do I have another procedures to do more?
Actually I tried alter database compatibility using a sentense below.
ALTERDATABASE mydatabase SET COMPATIBILITY_LEVEL = 140;
I worked and I can see the result 140 from sys.databases.
Is there anyone who can help me with this?
Thanks in advance.