When using SqlServerMembershipProvider/RoleProvider, the users and groups are stored in .NET default tables, not EPiServer-specific tables. The tables are prefixed "aspnet_*" and the tables you need are called:
The import/export feature in EPiServer does not include users and groups (only Visitor Groups), but you could export these tables using the "Script table as.." tool in SQL Server Management Studio, and then run that script to insert the data in your target database.
Yes, this one of the last resorts, which I've could imagine to myself, but it does not address following possible issues:
1) Whatif somebody on target installation already added more users and/or roles that I have?
2) Still, security setup would not be transfered in that way :(
Let me exaplin a little bit: I am newcomer to EpiServer from Sitecore. Sitecore strongly discourages any direct database operations, and, actually, stores users and groups in the same way, as EpiServer does (using .NET default tables). But, Sitecore allows to export/import users and security... Maybe there is a way to accomplish this task with EpiServer?
You could hookup to Export/Import and add additional data to the package e.g. as described here: http://world.episerver.com/Blogs/Johan-Bjornfot/Dates1/2011/3/Mirror-other-than-content/
However as mentioned in that blog post users are tricky to export/import since the Membership API does not support to retrieve the password in cleartext (which is obvisouly good for security reasons). And since EPiServer supports different kinds of providers it is not possible to access user data in a "lower" layer (e.g. database) than Membership API.
But if you are using a specific provider you could do it your self at a lower level for example as Arild suugests.
Thanks, just one quick question:
http://world.episerver.com/Blogs/Johan-Bjornfot/Dates1/2011/3/Include-ACL-during-Import-Mirroring-and-Copy/ - do EpiServer 7 still also include ACLs in Exported content?
Cause if yes, than your prior module seems to fullfill my needs completely (users password problem is known to me, it is also the same in Sitecore - user would be delivered, but in locked state and without any password), so actually, I do need only Roles to be exported /imported correctly to keep consistency over environments
Yes, the ACLs are still included.
Thanks. That's awesome and perfectly fits then in our CI strategy :)
Just some coding and we would be into business back
Sorry, but I was not able to find an answer on aforementioned question, which is:
Is it possible to import/export users and groups in Episerver 7.1, while using SqlServerMembershipProvider and SqlServerRoleProvider by using CMS only means?