Register | Log In
Store Download Support Blogs Forums Contact
Resources > Forums
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0How to export all users to another DNN application?How to export all users to another DNN application?
Previous
 
Next
New Post
11/26/2007 1:06 PM
 
User is offline bo ma

Joined: 6/22/2005
Posts: 46

How to export all users in current DNN to another DNN application?

I got 2 DB

DB 1: dotnetnuke1 (new DNN 4.7 install, only with admin, host)
DB 2: dotnetnuke2 (old DNN 4.3, with about 100 or more users)

I want to append/Add all users under dotnetnuke2 to dotnetnuke1?

THanks!

 
 
New Post
11/26/2007 10:43 PM
 
User is offline Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 34241

there are 3rd party modules available,  (e.g. I lately used one from PHD), please have a look at the marketplace and SnowCovered.com.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals
 
New Post
11/27/2007 11:22 AM
 
User is offline bo ma

Joined: 6/22/2005
Posts: 46

I try to import following table:

[dbo].[aspnet_Membership]
[dbo].[aspnet_Users]
[dbo].[UserPortals]
[dbo].[UserProfile]
[dbo].[UserRoles]
[dbo].[Users]

but it's always shows some error
 
New Post
11/28/2007 6:49 AM
 
User is offline Mitchel Sellers


Mitchel Sellers's Avatar

Mitchel Sellers's Avatar

www.mitchelsellers.com
Joined: 1/24/2007
Posts: 7552

The only way you could do a direct table copy is if you have the same machineKeys in both applications otherwise the passwords would not work, you must also then ensure that you turn on identity insert, insert them in order, and ensure that you will not have a user id conflict.

I would really look at a third party module to do this unless you are VERY familiar with database inserts, updates etc.

-Mitchel Sellers
Microsoft C# MVP, MCITP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Consulting Quotes, and DNN Technical Support Services

I recommend PowerDNN and 3Essentials for DotNetNuke Hosting and BaseCamp for project management
 
 Page 1 of 1
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0How to export all users to another DNN application?How to export all users to another DNN application?


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
Attend A Webinar
Free Demo Site
Download DotNetNuke Professional Edition Trial
Have Someone Contact Me
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

DotNetNuke Scoop!

Sponsors

DotNetNuke Corporation

DotNetNuke Corp. is the steward of the DotNetNuke open source project, the most widely adopted Web Content Management Platform for building web sites and web applications on Microsoft. Organizations use DotNetNuke to quickly develop and deploy interactive and dynamic web sites, intranets, extranets and web applications. The DotNetNuke platform is available in a free Community and subscription-based Professional and Enterprise Editions with an Elite Support option. DotNetNuke Corp. also operates the DotNetNuke Store where users purchase third party apps for the platform.
Copyright © 2002-2012 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP