Hamish Watson shows how easy it is to synchronize SQL authenticated logins using dbatools:
When building new servers the most important thing after restoring and securing the database is syncing up the users. This is especially important for Availability Groups as SQL Authenticated users required the SIDS to be the same.
In the past I had some very long winded code that would do the sync – it was a mixture of TSQL and PowerShell. It worked but you know – it was cumbersome.
Read on to see how life gets easier with dbatools.