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

Avyayah 1,231 Reputation points
2020-03-12T21:02:40.1+00:00

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

Azure Service Fabric
Azure Service Fabric
An Azure service that is used to develop microservices and orchestrate containers on Windows and Linux.
252 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,576 Reputation points
    2020-03-13T07:51:04.807+00:00

    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

    1 person found this answer helpful.
    0 comments
  2. Armand Brunelle 491 Reputation points
    2020-03-12T21:17:45.43+00:00

    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.

    0 comments