Bill,

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

---

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