Hi,

Can you recommend a module for copying users registered in DNN2 running msaccess INTO DNN3 running SQL?

I'm in the process of upgrading and dont want to lose all my registered members.

 

Thanks.

Hello,

If I was approaching this I would open MSAccess and copy all of the data from the Users table and paste it into the Users table for my New installation of DNN (Using Enterprise Manager for SQL Server).

I would copy the data to a localhost installation so that you have a backup copy of all of your users and can test that you have transferred the data across correctly before attempting it on a live site.

I would double check that the passwords still work correctly and that you can login as various registered users.

I have copied all the users from DNN2 to xls file.

But which table I need to copy in DNN3 ? There a lot of tables with userxxx and aspnet_xxxx.

Do I need to copy to aspnet_membership table - > bcoz that has got password field in it ?
Or does it need to copied to 2-3 tables ??????

Also I haven't got DNN3 setup on my laptop, is it safe to copy live it on the server.

Any advice .....

ok, I responded to this without double checking the DNN 3 table structure, the membership system changed from DNN 2 to DNN3 - the major thing is that passwords are now encoded. Because of this I don't know what to suggest and it will take me a couple of hours to research, so I would have a look at the links below for suggestions & request that when you find the answer to let us know so that we can share the information with the rest of the community.

I would not attempt anything that you are unsure of on your live server, it is just not worth the risk. Test it on a localhost install - get a localhost install setup, you will always find it useful for testing certain elements.

You may be able to find help with the bi4ce team that I interviewed at:
http://dnn.bi4ce.com/Forums/tabid/2...fault.aspx

They have a lot of experience with working with the dnn database & may have already solved this problem.

The other resource I would go to is the asp.net forums: http://forums.asp.net/90/ShowForum.aspx

Hope this gives you a starting point,

Following this up, I've just come across a module which covers exactly what you need:

BulkUser Import and Export

It's available at snowcovered, thanks,