If I have log shipping configured between 2 sql servers on premise, then, in addition to the database data and schema, will the database user permissions and server login permissions/role membership get synced. Or is there any other configuration to achieve this?
1
-
You might want to take a look at PowerShell ❤ SQL Server (dbatools.io) and then possibly the video they posted on their site: Watch a SQL Server to SQL Server Migration. <= free. There are other paid options that you could consider. Red-Gate SQL Compare being one. ApexSQL.com has some tools that might assist you with migration tasks. I'm in no way affiliated with these companies.– John K. N.Apr 12, 2022 at 10:47
Add a comment
|
1 Answer
Database users, roles, role memberships, and permissions are stored in the database and will be transferred by log shipping.
SQL Logins would need to be synchronized between the instances using a different mechanism. See eg Transfer logins and passwords between instances of SQL Server
answered Apr 11, 2022 at 17:55
-
Thanks for the link. Do you know whether the script from that link is idempotent. That is - can be run several times without any negative effect?– variableApr 12, 2022 at 9:56