Copying ASP.NET Membership Tables via SSIS

Hello,

I am trying to copy a database that contains ASP.Net Membership tables from a development server to a production server and I'm having the seemingly common issue of violating FK constraints on the new table when trying to import data via the Import/Export Wizard in SSMS.  

I've read multiple posts regarding the fact that you have to transfer the tables over in the correct order, however nothing that specifies what order is the correct one.  Also, I'm not sure how I can actually order how the tables get imported into the database.  Does anyone know how I might get this done?

Thanks,

Mike
LVL 3
MClarkCCRAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ezraaCommented:
If you are able to overwrite the production database, I would recommend that you backup the database on the development server and restore it on the production server.  I have done this many times.  

Otherwise, you can import in this order:

aspnet_Applications
aspnet_WebEvent_Events
aspnet_SchemaVersions
aspnet_Paths
aspnet_Users
aspnet_Roles
aspnet_Profile
aspnet_UsersInRoles
aspnet_PersonalizationPerUser
aspnet_PersonalizationAllUsers
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ezraaCommented:
I missed aspnet_Membership that can be imported after the aspnet_Users table.
0
MClarkCCRAuthor Commented:
Thanks for the help.  I created an SSIS package that transfered the tables in order and it worked pefectly the first time!! (How often do you get to say THAT in development?)  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.