Tuesday, May 6, 2008

Lotus Notes to Sharepoint migration

I got an excellent opportunity to do some R&D on Lotus 2 MOSS Migration.
It seems really cool that u can easily actually migrate your Lotus Mails, Access Control Lists (ACL) and Domino Directory Users as well as Lotus Notes Applications like Lotus Document Libraries, Discussion Boards, Team Rooms, Calendar etc to Sharepoint document libararies, lists, discussion boards and calendar lists...using migration tools like Microsoft Transporter Suite (click here to download),

I also used a limited version of Notes Migrator for Sharepoint by Quest software, it is actually a fantastic tool, i migrated a Lotus doc library to MOSS List as well as MOSS doc library and it gave fantastic results better than Microsoft's Transporter suite.

The key differentiator is the ability of Quest to actually create doc libraries/lists on fly and auto-map notes and moss fields. So even if you do not have MOSS library/list created, using the tool you just need to specify the fields from Lotus application that you wish to migrate to Sharepoint List/Library & then do an Auto-Map.

You can even migrate your ACL as well your Active Directory using this tool, on the other hand Microsoft's Transporter suite isn't bad either, it also does an mediocre job of migration for you.
(However, i personally can't vouch that all the fields of notes application will appear in moss library/list based on my experiences with the tool...)
It even allows you to migrate your Lotus Domino Directory to Active Directory as well as to Exchange server.

If you find this post useful, please drop in a few lines....

33 comments:

  1. Good one Mehul....I really want to try this migration and let you know once I achieve it...Thanks for the help...keep going :-)

    ReplyDelete
  2. I am presently writing a research paper on the migration front for my organization. If you need my help, just email me...

    Thanks for all the encouragement and support.

    ReplyDelete
  3. LN to SP MigratorJuly 3, 2008 at 7:00 AM

    Hi Mehul

    Our organization is also moving away from Lotus Notes to Sharepoint and we are using ecKnowledge tool for the same.
    I was wondering what we need to migrate the Notes ACL to SP. How can I get a $ec_dbacl in SP.

    Any help would be greatly appreciated.

    Thanks

    ReplyDelete
  4. Since, i am using Quest's Notes migrator for SharePoint (NMSP), it directly maps the users in notes ACL to SharePoint User/Group Permissions , but these Groups/permissions need to be created manually in SharePoint at the Site level prior to your migration activity.

    NMSP then creates all the users with specific rights/permissions, when migrating from Notes to SharePoint.

    NOTE: You need to move your users from Notes Domino directory to your Active Directory prior to this migration activity.

    But i am not sure how it works out in ecKnowledge, because i have never used it.
    Do let me know, if i you want me to clarify further...

    ReplyDelete
  5. ln to sp migratorJuly 4, 2008 at 5:26 AM

    Thank you for your prompt response Mehul.

    I am actually stuck with the way ecKnowledge treats this job internally.
    I know they work on a view $ec_dbacl but somehow it is not available by default and I am not sure how to get it:(

    ReplyDelete
  6. Hi Mehul,

    Though very late, this post was found to be very useful as I am proposing the right tool to a customer for Lotus Teamroom to MOSS migration. I am now confident that my choice of Quest Notes Migrator for SharePoint is precise.

    Thanks again.

    Sunil

    ReplyDelete
  7. I am looking to convert a lotus notes database / library and workflow application to MOSS. Are you able to recomend a vendor to perform this?
    Simon.roche@fonterra.com

    ReplyDelete
  8. Hi, do you know where i can find information about how transporter suite mapps NOTES ACL to MOSS ACL, role-->role

    Somebody help please :)

    ReplyDelete
  9. Hi,

    As far as my knowledge and experience, I don't really think Transporter suite really supports ACL migration, it is a basic/free migration utility with some inherent issues.

    I generally recommend Quest's Notes Migrator for Sharepoint (NMSP),which gives you the option to migrate Notes ACL to MOSS ACL, Steve Walch is the man to watch out, he interestingly points out the key differentiators between Transporter suite and Quest NMSP, http://notes2sharepoint.org/archive/2008/05/29/what-is-the-difference-between-notes-migrator-for-sharepoint-and-microsoft-application-transporter.aspx

    ReplyDelete
  10. Hello Mehul, what is your take on migrating from notes to SharePoint manually. I have a client who wants to go that path.
    Rajesh@alliedgroups.com

    ReplyDelete
  11. Hi Raj,

    How will you migrate data from Lotus notes application to Sharepoint lists/libraries using the manual approach, it will be cumbersome and error prone...

    think abt it...use Quest Notes migrator for Sharepoint for migrating data on the fly, then you can actually focus on building the complex forms and workflows in sharepoint...

    ReplyDelete
  12. Hi Mehul,

    Which edition of Notes Migrator have u used (Discovery Edition Standard Edition Premier Edition)? Also, is it possible to carry out the migration using freeware tools like Microsoft Transporter Suite?

    Request you to kindly revert asap.

    Thanks,
    Denil

    ReplyDelete
  13. I have used the Notes Migrator Standard Edition v 4.5, i guess they now have 5.0 as well.

    Yes, it is possible to use Microsoft Transporter suite, but it isn't very effective in migrating complex notes data. Quest NMSP is very powerfull as widely accepted.
    I have evaluated Transporter suite and is not at all good specially in terms of reliability. I personally recommend Notes migrator for Sharepoint.

    Visit this blog for more information: http://notes2sharepoint.org/archive/2008/05/29/what-is-the-difference-between-notes-migrator-for-sharepoint-and-microsoft-application-transporter.aspx

    ReplyDelete
  14. Thanks Mehul for the prompt response. What would be the approximate cost of Notes Migrator Standard Edition v 4.5?

    ReplyDelete
  15. Hi Mehul, I have got an assignment to migrate Lotus Notes data to Sharepoint. Want to know from you that what amount of Sharepoint knowledge should I need to know for this migration. I am a Lotus Notes resource. u can contact me on bose.pritam85@gmail.com

    ReplyDelete
  16. Its Really nice article..its good for the people who r in sharepoint and want to face any challanges in integration with any tool... :)

    ReplyDelete
  17. Quick question, i only want to migrate a notes document library to a Sharepoint document library, will Transporter do this? Thanks.

    ReplyDelete
  18. Its really very good blog. I didn't expect this much of info from your side. I will catch you soon with lots and lots of questions......

    ReplyDelete
  19. QUEST´s NMSP is not able to migrate LN workflows. Anybody here who can tell about a tool which is able to migrate workflows?
    Any help is greatly appreciated.

    ReplyDelete
  20. Quest's NMSP is designed to migrate data from SharePoint Lists/Libraries, autogenerate your Lotus Business Process Forms to InfoPath forms, but it cannot migrate workflows for you, I dont believe there is any tool available that migrates the workflows as well.

    You need to re-create them using Visual Studio Windows Workflow foundation for SharePoint. However, if you choose to easily create workflows for SharePoint, then you might evaluate Nintex workflows.

    ReplyDelete
  21. Thanks for your help, Mehuil.
    Found this Nintex Workflow tool on the web. Seems to be interesting for my company. I´ll do the trial. Cheers
    PEB

    ReplyDelete
  22. But you still have to manually create workflows using Nintex, no tool will migrate the workflow from Lotus Notes to SharePoint automatically.

    But Nintex makes your job of creating workflow easier, I have personally worked on Nintex for 1 year and can vouch that its a fantastic product.

    ReplyDelete
  23. This comment has been removed by the author.

    ReplyDelete
  24. Mehul,

    My company is planning to Decommission Lotus notes. My company has Nintex work flow licence. Do we need other tools like Quest to do lotus decommission only nintex will do if we have work flow only on lotus notes.

    Regards,
    Amit

    ReplyDelete
  25. Mehul,

    My company is planning to Decommission Lotus notes. My company has Nintex work flow licence. Do we need other tools like Quest to do lotus decommission only nintex will do if we have work flow only on lotus notes.

    ReplyDelete
  26. You would need Quest NMSP to perform Data migration from Lotus Notes to SharePoint. You would additionally need Nintex workflows for performing the workflow migration

    ReplyDelete
  27. CORRECTION : Nintex workflow to perform Workflow re-creation.

    ReplyDelete
  28. Hi Mehuil, great, really useful blog. Question - my company is looking to migrate Lotus Notes document databases to SharePoint using a 3rd party migration tool. What is the best practice in terms of transferring the database to libraries vs lists? Our IT consultant insists on lists, but it seems libraries are more flexible and would be a better starting point. Would appreciate your comments, thank you.

    ReplyDelete
  29. The migration of Lotus Notes applications is a complicated and a time consuming task but with the help of perfect guidance as mentioned here it would be easy to deal with it. I have once tried it and found it useful too.

    ReplyDelete
  30. VisiMigrate offers out-of-the box functionality to transform content from common Lotus Notes databases such as document repositories, discussions, and tasks to SharePoint Lists, Document Libraries, and more. See more at http://www.visionetsystems.com/visimigrate.html

    ReplyDelete
  31. This comment has been removed by the author.

    ReplyDelete
  32. A special thanks for this informative post. I definitely learned new stuff here I wasn't aware of !

    ReplyDelete
  33. Hi, Can some one help where we need to install the quest tool(on Lotus notes server or SharePoint server or any other server). Also, Please clarify me where this tool data will be stored?

    ReplyDelete