MSSQL: Sync Logins using Powershell

Need to develop a powershell script (using DBATools module), to sync logins from Primary to Secondary servers on all MS SQL instances hosted on a single server.


1. Get all SQL instances hosted on a server.

2. Identify Primary instance, and its corresponding Secondary instance in Mirroring and AlwaysOn set-ups.

3. Get Login and SID details from Primary & its respective (all) Secondaries.

4. Compare Primary & Secondary (use loop, as there can be more than one Secondary), and insert any difference between Login & SID details in a separate table.

5. Call DBATools module, to fix any Login and SID details mismatch (from Primary to Secondary) using Force option

6. Log table on primary; create if not already exists and log each step

This is a high level explanation; some small changes might come up in further discussions.

Evner: Microsoft SQL Server, Powershell, Software Arkitektur, SQL, Windows Server

Se mere: sql server sync logins, sync sql logins between servers, copy-sqllogin, logins aren't syncing across availability groups, sync sql agent jobs, sql alwayson sync logins, dbatools sync logins, sql server script logins and permissions, design website using joomla need template pages, create sql log history using aspnet, need 1000 dating site use, using powershell automate account creations excel, changing dsn odbc using powershell, need monster images can use site, using joomla need, mssql aspnet connect using, need english version compare spanish version, offline sqlite sync server using html5, file sync server using java, edid info using powershell

Om arbejdsgiveren:
( 0 bedømmelser ) New Delhi, India

Projekt ID: #18335496

6 freelancere byder i gennemsnit ₹10205 på dette job


Hi there My name is Sergio and I am a software developer here at the freelancer com marketplace. Thanks for using our marketplace! I am strong with PowerShell scripting and can get Sql Server to sync logins. If inte Flere

₹10800 INR in 2 dage
(65 bedømmelser)

I am confident I am the right candidate for this project as I have done many similar projects in the past. With years of experience in this field, I believe this project will be very easy for me.

₹18375 INR in 6 dage
(2 bedømmelser)

Hey, I am Nadav! I have a lot of experience with Powershell scripting. I wrote tons of Powershell scripts that work with MS SQL. I can finish the script in just few days, let me know if you are interested.

₹4000 INR in 3 dage
(1 bedømmelse)

Hi. This Software Project is looking to be Quite Complex. Its Degree of Difficulty might be close to that of High Difficulty. The Main Issue is the Fact that the Resulting "Microsoft" "Windows" "PowerShell" S Flere

₹10000 INR in 30 dage
(1 bedømmelse)

I have 5 years experience in Power shell along with SQL server.I have carefully gone through the requirement,the main purpose is to sync the secondary server from primary server in terms of login details I am confident Flere

₹5555 INR in 5 dage
(0 bedømmelser)

Dear Customer, Request you to please provide us opportunity to work with you. we are having amble of experience in IT industry to work on multiple technologies. Regards Yogesh Mehta

₹12500 INR in 3 dage
(0 bedømmelser)