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: 273

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

Related posts about sql-server-2008

Related posts about ASP.NET