Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in D:\inetpub\phost\wordpress_sites\paultiemann\wordpress\wp-includes\functions.php on line 6114
ASP.NET Archives - Paul Tiemann's Website

Migrating Sitecore users from one instance to another without losing their passwords using SQL 2008 R2.

by | Jan 7, 2014 | ASP.NET, CMS, Sitecore

You can copy Sitecore users from one instance to another using a package however their passwords will be reset. If you want to copy users without losing passwords The Inside Corner site has a page that describes how to migrate Sitecore users from one installation to another: http://www.theinsidecorner.com/en/SiteAdmins/SiteSecurity/SitecoreAccounts/MigratingAccounts.

This description is a bit out of date if you are using the database script method with SQL Server 2008 R2 because the SSMS wizard has been changed.
Here’s how to do it with SQL 2008 R2:

  1. Right click on the core database and choose Generate Scripts
  2. If SSMS shows an Introduction page, click next
  3. Select specific database objects
  4. Expand Tables
  5. Select all tables with a name starting with aspnet_
  6. Click next
  7. Select the advanced button
  8. Change “Script DROP and CREATE” to Script DROP and CREATE
  9. Change “Types of data to script” to Schema and data
  10. Choose whatever option to save the script that works for you, clipboard, file or new query editor window.

Cheers,
Paul
PS: I suspect this would work with any ASP.NET site that uses the membership provider but who does regular asp.net sites anymore?