Hi @lin ,
The SID is not possible to transfer between OnPremise environment to Azure SQL Database. You will get the error message if you execute the T-SQL. Please refer to Lesson Learned #35: How to transfer the login and user from OnPremise to Azure SQL Database to get more information.
You can move SQL logins from the source SQL Server to Azure SQL Database using Database Migration Service (DMS) in offline mode. Use the Selected logins blade in the Migration Wizard to migrate logins to your target SQL Database. Please refer to Logins and groups to get more information.
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.