Migration Flow is an all-in-one solution for migration and automation. It is designed for SharePoint content migration, restructuring, enrichment with active use of any external data source such as SQLServer, csv, odbc.

For example data from SQLServer, csv, Excel etc. can be seamlessly combined with files from a FileShare and dynamically migrated into SharePoint Document Library Items – effectively migrating any legacy DMS to SharePoint in Office 365 or or-prem.

  • In a typical migration project a classic tool is the corner stone. All automation-logic, data retrieval and error handling is custom coded in PowerShell and the classic tool is used as a utility to perform the file copy to SharePoint. With Migration Flow the approach is different and the project is made of configurable Steps that are designed for content migration, data extraction and automation with no code required.
    In other words a fundamental change in the way you approach and execute migration to the Digital Workplace.
  • The foundation for transfer to O365 is the SharePoint Import Migration API. The product’s implementation uses advanced tracking that guarantees reporting on each file while at the same time utilizing asynchronous high performance transfer. This unique technology results in high migration throughput even during Azure datacenter production hours and brings throttling to an absolute minimum.
  • Microsoft PowerAutomate cloud flows can be invoked for incremental notification and invocation of approval workflows as the migration progresses.
  • The consolidated migration reporting is built in and the data set is accessible using SQL from PowerBI or other database reporting solution.
  • Migration On Demand – Prebuilt template for centralized SharePoint List based migration job management. The migration jobs are created as list items and you can apply your own UI on top using PowerApps add workflow logic etc. using PowerAutomate.
Features matrix : Classic Migration tools vs. Migration Flow Classic Flow
Copy SharePoint sites 1:1 with schema and permissions Yes
Pre-migration “tenant/SP Server health” reporting Yes
Simple Drag and Drop user interface Yes
Function as a “code module” for inclusion in PowerShell driven migration projects Yes
Migrate files from FileShare or SharePoint to Teams or any SharePoint platform Yes Yes
  • No-Code automation and use of external data sources
Yes
  • Automation driven from external data sources. Columns becomes variables For-Each row. For-Each loops can be nested and the built in tracking and reporting details all actions within each branch/iteration
Yes
  • High performance 24/7 async transfer to SharePoint Online (½TB – 10TB/day).
Yes
  • Data ETL (Extract ,Transform and Load) between data sources including SharePoint List and Libraries, SQLServer, CSV etc.
Yes
  • OnDemand Migration. Jobs controlled from a SharePoint List
Yes
Data staging to data source (including databases and SharePoint List) with transformations. Extract from SharePoint or any data source. Yes
Combine metadata from external data source with files from FileShare to create Library Items Yes
Apply/reapply transformed metadata from from any data source Yes
Database based reporting, tracking and analysis (no text log files etc.) Yes
Notification and approval work can be invoked using Power Automate on job or For-Each loop level) Yes
2-way CRUD operations on SharePoint List/Libraries and data sources tables Yes
Reporting on any migrated files or any data source (see table below) Yes
Embed 2-way parameterized PowerShell to include proprietary functionality. You can call PowerShell for-each-row or just once. PowerShell core 5 & 7 supported. ISE and Visual Code supported as embedded editor. Yes
Excel-style calculation engine with variable support Yes
All SharePoint data types supported. Lookups, Managed Metadata, Labels and Content-Type can be resolved using dynamic calculations. Yes
SharePoint Online user names in all user columns like ModifiedBy, CreatedBy can be accepted regardless of existence. Even custom calculated names like “My department”. This is also true for version history. Yes
Pure 64 bit Desktop Cloud App. You control all data transfers. No cloud service needed Yes
External data sources include (CRUD = Create, Read, Update, Delete) Support
  • SharePoint Lists and Libraries – Visual CRUD
Read/Write
  • SQL Server – Visual CRUD or native SQL
Read/Write
  • Microsoft Access – Visual CRUD or native SQL
Read/Write
  • Generic ODBC – Visual CRUD or native SQL
Read/Write
  • CSV – simple extraction or advanced criteria on all data types
Read/Write
  • Excel – Sheets, tables: including refresh when connected to data source
Read/Write
  • JSON – automatic serialization
Read
  • XML – extract tag data and rows based on custom delimiters
Read
  • FileShare inventory scanning
Read

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment