Deleted one membership table. Possible to import without breaking relationship?
Posted
by superexsl
on Server Fault
See other posts from Server Fault
or by superexsl
Published on 2010-04-22T18:40:14Z
Indexed on
2010/04/22
18:43 UTC
Read the original article
Hit count: 304
Hey,
I hope this isn't going to be tricky/time consuming, so fingers crossed. I'm working with the ASP.NET membership table. However, I've got quite a few other tables that I've built, and most of them have a relationship with the dbo.aspnet_Membership
table. I've accidentally deleted the dbo.aspnet_Membership
table and can't get it back. There was no major data on it, (as it's on my local machine), but I would really like to copy and paste that one table from another database I have, mainly for the sake of not breaking the schema. Is this possible? I'm worried if I run the Aspnet_regsql.exe tool, it's going to break the schema and remove all data from the tables as well the relationships (which would take a while to re-establish). Is there any way I can import just the dbo.aspnet_Membership
table into my current database?
Thanks for the any advice!
© Server Fault or respective owner