B.Sc. of Computer Science from faculty of computer and information sciences -Ain Shams Univ,Cairo,Egypt. I have MCAD.NET,MCSD.NET,MCTS (SQL 2005) Early Achiever ,MCT & C# MVP. I'm INETA User group lead & DotNet Boom supportive development manager for www.dotnetboom.net community as well. I'm working as Consultant as well as Technical Lead. I like to learn more and more about new technologies.I like also to help & share information with others,Keep your eye on my blog.

Sunday, April 08, 2007

Migrate your portal from Non DNN to DNN 4.x version

Hi Folks,

I tried to migrate a non dotnet nuke portal to dotnet nuke portal version 4.x,the first problem you will face is that you want to migrate your existing users to the new portal ? this post will show you how to do it in easy steps :

1) Export your users into an excel file.
2) create a script to that call 2 stored procedures in DotNet Nuke DB :
aspnet_Membership_CreateUser
dnn_AddUser (in some versions its called Add_User)

You can create a script for all users exported in excel file using new feature in Office 2007 called Field Merge,simply open new word file and u will find it under mailing ribbon.

you want to know how to create a field merge in word 2007,simply i will invite you to watch my friend's webcast to how to create/use field merge in word 07.

http://dotnetking.com/HowTo.aspx - > WOW....... it's free.


After creating this script in word file,execute the script in any query analyzer on the remote or production server,and u will see all your users has been migrated successfully.

Enjoy ! with Field merge :) thanks Microsoft for this great feature.


Regards,
Moustafa arafa

0 comments: