How can I restore selected ASP.NET Membership users from a backup DB? -
had recent issue cms , discovered today of users created in last week deleted. news have backup of db, , uses standard asp.net membership tables.
is there way restore of data without restoring whole db? membership tables of maze... there existing stored proc or utility out there? i'm not sure tables required , ones not.
i'm not aware of single sproc or utility this.
if you're using membership, you'll need copy from:
- aspnet_membership
- aspnet_users
if you're using roles you'll need copy from:
- aspnet_usersinroles
if you're using profile you'll need copy from:
- aspnet_profile
so it's not bad. need roll sleeves , write between 2 , 4 insert statements. (that's theory @ least)
Comments
Post a Comment