Moving ASP.NET Membership Data to Production

All,

We have a ASP.NET application working on our staging server/DB. The application works fine. We are using ASP.NET Memebership/Roles, etc.

Now it's time to deploy the application to production. As part of the deployment, we want to copy/migrate the ASP.NET Memebership database to the production servers.

Can we simply do开发者_运维技巧 this via SQL Server's export/import functions? Will the applications IDs and role IDs that move to the production DB make sense when the ASP.NET application is deployed on the new boxes?

Thanks, John

Yes, this is fine. The IDs are all for internal storage, so no issue. Just make sure the config matches and you are good

You might want to look at RedGate's SQL Data Compare as a more robust (configurable) solution to moving data between databases. I think you'd probably be ok doing a simple export/import, but you'd need to be careful of autogenerate columns.

Use the Database Publishing Wizard from within Visual Studio?

http://social.msdn.microsoft.com/Forums/is/vssetup/thread/42bbad47-5b6e-4e99-8d27-07bcbd123064

Everything should work fine on the production server.