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

Kaung Htet Naing 46 Reputation points
2022-01-25T08:47:17.06+00:00

@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)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,256 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2022-01-26T03:18:35.293+00:00

    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".

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,706 Reputation points
    2022-01-25T12:52:54.79+00:00