Learn More





Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Best option for migrating usersBest option for migrating users
New Post
10/7/2013 7:37 PM

I am moving a DNN site we have been hosting on our own equipment to
DNN is installed and now I need to migrate the users to the new box.

Theres 300- 400 users with custom profile properties.
I am looking for a free app or module to help with this.
I did look quickly at one I found but it didn't do the custom properties.

Any ideas

I started to write my own but I am just too busy to continue with that.
I hope to ind a free solution because I was already paid for this work and would have to pay out of my own pocket if I need to purchase anything.

Since this is a clean install, maybe I can simply import table data from one DB to the other?

I guess that depends on if there are many changes between the 2 DB's

New Post
10/8/2013 2:49 AM

importing table data from one to the other should be possible - but take care:

- I don't think that this can be done without a script and some helper tables, so if you do this: test, test, test before you really do it on your production environment
- User IDs (and not usernnames) are the primary key, so take care
- maybe there is a need to transform the Role IDs where the users belong to as well (table UserRoles)
- and also the Portal IDs (table UserPortals)
- there are two User IDs in the User Relationship table, so if you don't want to loose the "friendships" etc. there is an extra-challenge.
- User IDs can also be used in tables of other modules (forums, blogs, shops, journal...)

So, if you do this you should be very careful and know exaclty what you want, what's your needs and what you are doing. I am not sure if there is some program, script etc. that can do this, but have a look in the store, or maybe something can be found in CodePlex, GitHub...

Best wishes

Michael Tobisch
DNN★MVP - Michael Tobisch's Site about DNN, SQL Server, ASP.Net and other related stuff - The most vibrant community around the DNN-platform
New Post
10/8/2013 8:13 AM
I prefer using BulkUserManager from PHD ( - not too expensive and easy to use for export and import (via csv/txt files).

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals

Speed up your DNN Websites with TurboDNN
New Post
10/8/2013 3:53 PM

I was able to get it mostly done using SQL Management Studio- opening the remote DB and then importing from the local DB with different table names, then some scripting to copy the data from table to table.
You are correct in the identy column headaches.
I have it mostly done except no users are showing in DNN yet because of some things I need to tie up like the PortalID in UserPortals being incorrect - 4 in old DB and 0 in the new.

Would be nice if someone has a list of all the tables I need to process- I think I may be missing one or 2.

I found this but not sure what the asp tables are for or if I need to worry about them for a new site

aspnet_membership, aspnet_users, Users, UserProfile, ProfilePropertyDefinition, UserRoles, UserPortals

New Post
10/8/2013 10:19 PM
Check through the tables in this script (excludes Profile Properties) -


PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Best option for migrating usersBest option for migrating users

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?