Timeline for Move users / roles / passwords to new core database
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 10, 2022 at 19:09 | comment | added | jammykam |
Yes, you could but might be tricky to match/update user accounts, but might be fine for new users. I would recommend the TransferUserPasswords.aspx page though, along with packages/serialization. Went through this process just last week and it was very straight forward.
|
|
| Aug 10, 2022 at 14:06 | comment | added | lsubi | @jammykam, we don't have RedGate. Can the base SQL Server Import and Export Wizard do the job? Is there a significant difference between it and using RedGate? | |
| Jan 11, 2019 at 14:44 | vote | accept | Alex S | ||
| Jan 11, 2019 at 14:43 | comment | added | Alex S | @jammykam We also noticed new table in Sitecore 9 called UserLogins which has a foreign key to aspnet_Users. | |
| Jan 10, 2019 at 15:19 | comment | added | jammykam |
@AlexS No, items table does not contain any membership related details, only the aspnet_* tables (which are all standard ASP.Net membership tables) and the RoleInRoles table mentioned above. Not that permission settings of items is stored against the Item itself, in the __Security field.
|
|
| Jan 10, 2019 at 14:52 | comment | added | Alex S | @jammykam Can you elaborate on the SQL option where you say "You will need to ensure you migrate user data from the following tables at a minimum". Do you think Items table also contains records for membership info? | |
| Jan 10, 2019 at 14:51 | comment | added | Alex S | @chrisAuer Can you provide more details? Thank you | |
| Jan 10, 2019 at 4:41 | comment | added | Chris Auer | Redgate has always been my tool for moving users, passwords and all. | |
| Jan 10, 2019 at 3:55 | history | answered | jammykam | CC BY-SA 4.0 |