Migrating Accounts

Migrating Accounts

Migrating Accounts between Sitecore Environments

  • The Package Designer can be used to migrate users and roles
    • Passwords are reset to a random password on the destination environment
    • User accounts get locked on the destination environment
  • The Content Editor Serialize commands can be used to migrate users and roles
    • The Developer tab must be enabled by right-clicking at the top of the Content Editor
    • Passwords are reset to a random password on the destination environment
  • SQL Server Management Studio can be used to migrate users, roles, and profiles
    • Passwords are not reset on the destination environment
    • Accounts do not get locked on the destination environment

Steps to Migrate Accounts with SQL Server Management Studio

  1. Right-click on the database with the accounts and select Tasks > Generate Scripts...
  2. Select the Core database in the SQL Server Scripts Wizard
  3. Set the "Script Create" option to False and the "Script Data" to True in the "Choose Script Options" window
  4. Select only "Tables" in the "Choose Object Types" window
  5. Select all the tables with a "aspnet_" prefix that you require in the "Choose Tables" window
  6. Generate the script
  7. Connect to you destination database and run the generated script against it

Sources