Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Moving document from Documentum to ProjectWise
    • Sign In

    • Replies 4 replies
    • Subscribers 66 subscribers
    • Views 722 views
    • Users 0 members are here
    • powershell
    • projectwise admin
    • powershellscrip
    • ProjectWise PowerShell Modules

    Moving document from Documentum to ProjectWise

    Amol Sonawane
    Offline Amol Sonawane over 2 years ago

    Hi, 

    We are planning to move the Documentum data in to ProjectWise. We have around 2TB data that needs to be moved to ProjectWise.

    I would like to know if we can able to do it using the PWPS_DBA module.  

    Will like to know the best practices used in the industry we can used in the migration?

    Is there any module available in the PWPS to write the script for the migration?

    Thank you!

    Regards.

    Amol 

    • Sign in to reply
    • Cancel

    Top Replies

    • Brian Flaherty
      Offline Brian Flaherty Fri, Apr 30 2021 11:41 AM +1
      Once you extract your data from Documentum, you can use the cmdlets available within the PWPS_DAB module. Check out my blog. You should find some samples there. https://powerwisescripting.blog/
    • Brian Flaherty
      Offline Brian Flaherty Fri, Apr 30 2021 11:41 AM

      Once you extract your data from Documentum, you can use the cmdlets available within the PWPS_DAB module. 

      Check out my blog. You should find some samples there.

      https://powerwisescripting.blog/

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Cancel
    • Dan Williams
      Offline Dan Williams Fri, Apr 30 2021 2:27 PM

      Amol Sonawane,

      A few comments:

      • I would strongly recommend using PWPS_DAB 64-bit rather than pwps, which is only available in 32-bit, assuming that you could use pwps for the migration (I suspect that it lacks the functionality required).
      • I would recommend breaking up your migration into smaller chucks of data (I'm assuming that the "2TB data" is more about the amount of file content to be migrated, than all of the data involved).  Because of the nature of .NET, which is what PowerShell is using, performance and some other issues can cause you a lot of grief if you attempt to migrate too much data in one session.
      • You will get better performance, and more granular control of the process if you create your migration tool using the ProjectWise SDK.  Keep in mind that you can write your tool in a .NET language such as C#, but you will have to deal with using unmanaged code with managed code.  Fortunately, you can take advantage of "MostOfDavesClasses" to deal with that issue. 

      You can find "MostOfDavesClasses" here:

      https://github.com/DaveBrumbaugh/MostOfDavesClasses-CSharp-Wrappers-For-ProjectWise 

      And you can find some samples on how to use "MostOfDavesClasses" here:

       https://github.com/DanWilliamsAtBentleyDotCom 

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Amol Sonawane
      Offline Amol Sonawane Wed, May 19 2021 11:46 AM in reply to Dan Williams

      Thank you Dan! Plan is same as you have recommended, We are going to do the migration Project by Project. Just wanted to understand the with Powershell with reference of excel import sheet is it possible?

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Dan Williams
      Offline Dan Williams Wed, May 19 2021 9:50 PM in reply to Amol Sonawane

      I would say that it is "possible".  What I would recommend is that you experiment with a few Cmdlets like Import-PWDocumentsBySpreadsheet, perhaps a few others as well, and see if it will work for your needs.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies