SQL Login users export

Question

how to export all SQL login users list ? is the any tools

Answer 1

If you want just a plain list, then you can query all SQL logins with

select *  
from sys.server_principals  
where type = 'S'  
order by name  

If you want to transfer SQL logins to different SQL Server, then you can use the Microsoft support script: Transfer logins and passwords between instances of SQL Server

Answer 2

Hi @Subash Thangaraj ,
Welcome to Microsoft Q&A.
We also can use dbatools in PowerShell to copy SQL server login.
To install dbatools, we can use Install-Module dbatools in PowerShell. Please refer to this article for more details.
Then we can use Copy-SqLogin and Export-SqlLogin to copy or export SQL Server login.
In addition, please refer to Migrate SQL Server Logins with PowerShell and Move or copy SQL Logins by assigning roles and permissions which might help.

Best Regards,
Amelia

---

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.