How do i backup SQL Server 2008 r2 databases to import to Azure SQL server

Question

@Alberto Morillo helped me solved my previous problem here below link
https://learn.microsoft.com/en-us/answers/questions/704490/how-to-backup-and-sync-mssql-local-database-to-azu.html

but i have facing another problem!! how do i backup sql server 2008 r2 databases to import to azure sql server?
right now, i have .bak files but azure unable to import using .bak file. so i download Microsoft Data Migration Assistant but i am unable to connect to azure.
Reason is : Login failed due to client TLS version being less than minimal TLS version allowed by the server.
My Product : Microsoft SQL Server Developer Edition (64-bit)
Operating System : Microsoft Windows NT 6.1 (7601)
SQL Version : 10.50.6560.0

first question is - how sql server 2008 r2 export BACPAC files?
how to upgrade TLS version?
Please help!

UPDATE!
I installed latest version of SQL Server Management Studio and All the options are available now! but now new error

One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71627: The element Login: [BBAPI\BBadmin] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.
(Microsoft.SqlServer.Dac)

Answer 1

Hi @Kaung Htet Naing ,

> Error SQL71627: The element Login: [BBAPI\BBadmin] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.

SQL Azure doesn't support windows authentication so I guess you'll need to make sure your database users are mapped to SQL Server Authentication logins instead.

Refer to this similar thread to get more detail.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

You should use DMS. See:
https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql