Copying Database Between Sites

[Jonathan Wood]

Greetings,

I've copied a significant database from an existing Website to a new one.
The database includes ASP.NET membership data.

I noticed that I am unable to successfully log on using any of the existing
accounts. I'm assuming it is because I changed the machinekey entry in my
web.config (my password format is encrypted).

So... I'm a little unsure how to add a new account to the new site, since
I'm unable to log on. I know the ASP.NET Web Site Administration Tool is the
best tool to use, but the more I think about it, the more it seems this is a
real pain. I'd need to create a temporary project, set the connection
strings to refer to database at the new site, set the new machine key, etc.

Isn't there an easier way?

Thanks.

Jonathan

 

[sloan]

You can check this:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!160.entry


But I don't know if it'll work with encrypted password.

Maybe it helps, maybe it doesn't.