Online Tutorials & Training Materials | STechies.com
Register Login

How to Copy data from Production to Development with all Permissions?

|| || 2

How to Copy data from Production to Development with all Permissions?
Stechies

Hello Experts,

May I know that how can we copy the data from production to development with all permissions?

Kindly assist here, thanks in advance.


Comments

  • 22 Dec 2015 3:47 pm

    Backup and restore is the easiest way to do it and fir permissions you need to script and run on restore. After restore, run sp_change _users_logins with report option.

    Check for missing permission and then again run the same SP with option update_one for already available logins and auto_fix for logina which are not available.

     

     

  • 22 Dec 2015 3:48 pm

    You can Take full backup of production DB and restore in dev. Transfer logins using ssis package(Visual studio) from prod to dev. Now run sp_change_users_login cmd to find orphan users. Run update_one to fix orphan users issue. Now your DB is aready in dev with all permissions as in the production.

Related Articles