Does the permission get copied when copy database from one server to another

Question

Does the Copy Database Wizard copy permission when copy database from one server to another.

Answer 1

The document below says - Logins are also copied to target server and also Limitation and restriction doesn't point out that we need to set up the permissions again on target DB.

https://learn.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard?view=sql-server-ver15

You may also raise this question in MSDN SQL server forum here - https://social.msdn.microsoft.com/Forums/en-US/newthread?category=undefined&forum=sqldatabaseengine

Answer 2

Hi @Avyayah

Can you be more specific please ?

What are you doing , on what platform, which system and version are you using ?

Normally from a copy and paste, it should copy everything you did copy from the main folder or .txt file.

Permission and access identification should remain the same.

Once your migration is complete, you can run the command : dsregcmd /status in Powershell

-------------------------

Please ''Accept as Answer'' wherever the information provided helps you to help others in the community.