Strategic Migration and Content Governance Platform
Executive Summary
SMART Migration is a strategic migration and content governance platform that enables the move of files from Microsoft SharePoint and M365 with metadata and version history from SharePoint, OneDrive, and FileShares to Nextcloud Files. The platform supports the entire migration lifecycle – from discovery and analysis of existing content to completion of the actual migration – supported by a comprehensive BI model that delivers real-time status and 100% file tracking. This ensures a compliant and secure migration.
—-
Summary
SMART Migration fills a critical gap in the market by enabling organizations to migrate away from Microsoft’s ecosystem to Nextcloud while preserving what matters most: metadata, version history, and content governance. The revolutionary Workspace concept, zero-footprint proxy links, and comprehensive Business Intelligence analytics make enterprise-scale migrations manageable, trackable, and successful. Unlike simple “lift and shift” tools, SMART Migration provides true content governance and analysis capabilities never seen before in migration tooling.
—-
Platform Phases
Phase 1: Discovery & Analysis
- Scan an entire Microsoft 365 tenant for document libraries
- Each library is scanned for content with detailed file-level information
- For each file: total volume across all versions and version count is captured
- OneDrive discovery included (each OneDrive is a site collection with one document library)
- Enables total insight into tenant content with tenant-wide “slice & dice” analysis
- Supports SharePoint On-premises (2007, 2010, 2013, 2016, 2019, SE), SharePoint Online, and FileShares
Special File-level detail captured:
- SharePoint: version count, complete volume based on all versions
- FileShare: last accessed date
This data is invaluable for planning, estimation, progress tracking, and performance statistics
Phase 2: Content Governance
- Auto structure suggestion for Nextcloud
- Re-organise content before migration using the Workspace concept
- OneDrive mapping to Nextcloud users (both migration and pre-analysis)
- Post discovery pre-migration: Analyse content, plan reorganisation
Phase 3: Migration and Validation
- Execute migration with full tracking
- MetaVox integration (optional but recommended)
- Multiple license options available
- Test migration capability
- Incremental migration – continuously migrate new files
- Post-migration analysis: verify where everything ended up
—-
Business Intelligence (BI) – The Analytical Powerhouse
SMART Migration includes a comprehensive Power BI-based analytics suite that provides real-time visibility into every aspect of the migration process. With version-aware volume analysis, organizations gain precise insight into true data volumes—not just file counts—enabling accurate job duration estimates and exact calculations of storage savings when offloading to Nextcloud. The multi-stakeholder dashboards ensure everyone from technical administrators to executive sponsors can monitor progress, analyze content, and make data-driven decisions without requiring access to the migration server itself.
Technical Implementation
The BI component is implemented in Power BI Desktop (free version) with data sourced from external SQL Server or PostgreSQL databases in near real-time. This architecture enables comprehensive monitoring, analysis, and decision-making throughout the migration lifecycle.
The source database can be external from the database hosting the SMART Migration engine repository, thereby enabling users who do not have access to the migration server to monitor and analyze the data. This separation of concerns allows project managers, stakeholders, and compliance officers to track progress without requiring direct server access or technical credentials.
Report Page Capabilities
| Topic | Purpose |
|---|---|
| Job Monitoring | Track job progress in real-time, monitor execution status |
| Job Analysis | Deep-dive analysis down to individual file level |
| Discovered Content | Analyze what exists in source systems before migration |
| Migrated Files | Track and verify completed migrations |
| Offloaded Files | Monitor files converted to proxy/URL files (SharePoint only) |
| Restored Files | Track reverse-migrated files back to SharePoint |
Version-Aware Volume Analysis
Unlike conventional migration tools that only report file counts, SMART Migration’s BI component analyses the complete version history of every file. This version-aware approach provides precise insight into the true data volume, enabling accurate estimation of job duration and resource requirements. When a document has accumulated dozens or even hundreds of versions over its lifecycle, the actual data volume can be many times larger than the current file size alone would suggest.
This granular version analysis is particularly valuable when planning offload operations or migrations to Nextcloud where source files are replaced with URL proxy files. By knowing the exact volume including all versions, organisations can calculate precisely how much SharePoint storage will be reclaimed. The URL file that replaces the original document in SharePoint retains all properties of the original file, including version history references, metadata, and custom columns, while pointing users seamlessly to the file’s new home in Nextcloud.
Slice & Dice Analytics
The dedicated discovery report page enables tenant-wide global deep analysis with full “slice & dice” capabilities. Users can filter by site collection, library, content type, or file type to analyse volume distribution across the tenant. This makes it straightforward to identify large files, aged content, and version-heavy documents that may be prime candidates for offloading. The insights gathered support data-driven migration wave planning and accurate estimation of storage requirements.
Near Real-Time Monitoring
The BI dashboards provide continuous visibility throughout the migration process. Progress tracking updates as jobs execute, displaying performance statistics, throughput metrics, and any exceptions or errors with drill-down capabilities. The multi-stakeholder view ensures that everyone—from technical administrators to project managers—sees the same data, eliminating discrepancies and enabling coordinated decision-making. Historical trending supports capacity planning and SLA compliance monitoring.
Data-Driven Decision Making
The BI component transforms raw migration data into actionable intelligence across all project phases. During pre-migration planning, teams can identify content patterns, estimate timelines, and prioritise migration waves based on business criticality and version volume. While migrations are running, the dashboards help monitor throughput, detect bottlenecks, and adjust resources in real-time. Post-migration, the reports verify completeness, generate compliance documentation, and provide audit trails for governance requirements.
Export & Reporting
All reports support standard Power BI export capabilities. Stakeholders can export filtered data to Excel for further analysis, generate PDF reports for management review, or schedule automated report distribution via Power BI Service. Dashboards can also be embedded in SharePoint or Teams for broader organisational visibility.
—-
Job Management via SharePoint & Teams
Simple List-Based Job Control
The entire system – discovery, planning, and execution – is managed through SharePoint lists connected to Teams. This approach makes job management intuitive and accessible.
How it works:
- Create a list item defining job parameters (source, destination, schedule)
- The system executes the job based on list item configuration
- Discovery output is sent to the BI database (MSSQL or PostgreSQL)
- Progress and status updates are written back to the list item
- If fewer than 300,000 files, an XLSX file is attached to the job item for detailed review
Benefits:
- Monitor jobs directly in SharePoint or Teams
- Track progress without leaving the Microsoft environment
- Analyse detailed output in Power BI
- Same workflow for discovery jobs and migration jobs
—-
The Workspace Concept – Revolutionary Content Governance
Proxy-Based Content Reorganisation
This technology has never been seen before. SMART Migration can discover files in their source locations and create proxy representations in a dedicated library named “Workspace”.
The Proxy Content Type holds:
- Original file name
- Original location/path
- File metadata
- Reference to source file
Work While Files Are In Active Use
Since proxies are created (not the actual files), the proxies can be:
- Rearranged into new folder structures
- Copied to multiple destinations
- Moved between folders
- Renamed as needed
All while the original files remain in active use by end users.
Define Structure, Then Execute
- Content owners arrange proxies into the desired target structure
- When ready, execute the migration
- The system fetches files from their original locations and migrates them to the designated destinations
- Files land in Nextcloud in the pre-defined structure
Parallel Workstreams
- Multiple Teams channels can work simultaneously
- Each channel handles their specific content area
- Functional separation between different content owner groups
- Decoupled timelines – no dependencies between groups
- Content owners make decisions (they know their content)
- Migration consultants coordinate and assist
NO MORE error-prone Excel spreadsheets with stupid tables.
—-
The Proxy Link Concept – SharePoint Coexistence
Zero-Footprint URL Files
When a file is migrated from SharePoint to Nextcloud, the source file can be converted into a URL file that points to the file’s new home in Nextcloud.
Key characteristics:
- When clicked, users are redirected to the file in Nextcloud
- The URL file has zero storage footprint
- Immediate reduction in SharePoint storage consumption
- SharePoint storage costs: ~$2,400 USD per TB per year
Gradual Migration Without Dual Editing
This concept has critical advantages:
- Files can be migrated gradually over time (even years)
- No file can be modified in two different places
- Only one version of truth exists at any time
- Users continue working seamlessly – they click the familiar link and get the file
Incremental Migration
- New files added to SharePoint after initial migration are detected
- System picks up new files automatically
- Migrates them to Nextcloud
- Converts source to URL file
- Continuous synchronisation until migration is complete
—-
Reverse Migration – Full Fidelity Return to SharePoint
Complete Restoration Capability
Files migrated to Nextcloud can be reverse-migrated back to SharePoint with full fidelity:
Option 1: Original Location
- Recreate the original file at its original location
- 100% version history preserved
- SharePoint-specific metadata restored
- Any new versions added in Nextcloud are included
Option 2: New Location
- Migrate to a new site collection
- Full version history maintained
- Complete metadata fidelity
- Useful for reorganisation scenarios
—-
MetaVox Integration – Structured Metadata for Nextcloud
What is MetaVox?
MetaVox is an open-source Nextcloud app that adds rich, structured semantic metadata to documents. Originally developed by the University of Amsterdam, it makes documents easier to organise, interpret, and retrieve.
“Vox” = voice. Metadata as “the voice of the document.”
SMART Migration MetaVox Support
| Feature | Description |
|---|---|
| Folder-level metadata | Resembles SharePoint Document Sets in simplified form |
| File-level metadata | Individual document metadata fields |
| Dynamic column association | Columns are dynamically associated to Team Folders |
| Direct mapping | SharePoint metadata maps directly to MetaVox columns |
| Transformation | Metadata can be transformed and combined during migration |
Integration Benefits
- Preserve SharePoint metadata investment in Nextcloud
- Maintain searchability and classification
- Support compliance and governance requirements
- Enable rich filtering in Nextcloud search results
—-
Flexible Destination Structures in Nextcloud
Automatic Team Folder Creation
SMART Migration offers multiple approaches for organising content in Nextcloud:
Option 1: One-to-One Mapping
- Automatically create a Team Folder for each source library
- Preserves original structure
Option 2: Consolidation
- Combine multiple source libraries into a single Team Folder
- Simplify structure during migration
Option 3: Dynamic Restructuring
- Select files from multiple source locations
- Migrate to an entirely new structure
- Complete reorganisation during migration
All options include full MetaVox metadata support and near real-time monitoring with deep analysis.
—-
Content Sources Supported
| Source | Supported | Notes |
|---|---|---|
| OneDrive | Yes | Each OneDrive = site collection with 1 doc library |
| Files in Teams | Yes | Standard document libraries |
| SharePoint Online | Yes | Full tenant discovery |
| SharePoint On-premises | Yes | 2007, 2010, 2013, 2016, 2019, SE |
| File Shares | Yes | Includes last accessed date |
Document Management Systems (DMS) – Migrating the “Impossible”
Many organisations have legacy Document Management Systems where content is essentially trapped. Standard migration tools cannot handle these systems because:
- Files are stored as anonymous blobs with GUID names (e.g.,
a3f8b2c1-4d5e-6f7a-8b9c-0d1e2f3a4b5c.bin) - The relationship between metadata and files exists only in a database
- Version history is tracked in database tables, not in the file system
- File names, dates, classifications, and relationships are database records
- Without the database, the files are meaningless binary objects
The SMART Migration Solution
SMART Migration bridges the gap between database metadata and physical files, enabling migration of otherwise impossible-to-migrate content into Nextcloud.
How it works:
- Connect to any database – SQL Server, PostgreSQL, Oracle, MySQL, or any ODBC-compatible source
- Read metadata and file information – Extract document names, dates, classifications, custom fields, version info, relationships
- Locate the binary content – Files stored in blob storage, FileShares, or content-addressed storage
- Reconstruct complete documents – Combine metadata with binaries to recreate meaningful files
- Transform metadata – Map, convert, combine, and enrich metadata during migration
- Construct version history – Build proper version chains with specialised version numbering
- Target MetaVox – Structure metadata specifically for MetaVox folder-level and file-level fields
Typical DMS Migration Scenarios
| Legacy System Characteristic | SMART Migration Capability |
|---|---|
| Files stored as GUIDs in blob storage | Reconstruct with original filename from database |
| Metadata in SQL tables | Extract and transform to MetaVox columns |
| Version history in database records | Rebuild version chain with correct ordering and dates |
| Document relationships (parent/child) | Preserve or transform relationships in Nextcloud structure |
| Custom classification schemes | Map to MetaVox metadata fields |
| Check-in/check-out history | Preserve as metadata or version comments |
Version History Reconstruction
Legacy DMS systems often track versions differently than SharePoint or file systems. SMART Migration can:
- Read version records from database tables
- Order versions correctly by date, sequence number, or custom logic
- Apply specialised version numbering schemes
- Attach version-specific metadata (author, comments, status)
- Recreate the complete version timeline in Nextcloud
- Target MetaVox version metadata fields
Metadata Transformation Engine
During DMS migration, metadata rarely maps 1:1 to the target system. SMART Migration provides:
- Field mapping – Source field A → MetaVox column B
- Value transformation – Convert codes to readable values (e.g., “ST01” → “Draft”)
- Field combination – Merge multiple source fields into one target field
- Conditional logic – Different mappings based on document type or other criteria
- Default values – Apply defaults when source data is missing
- Lookup tables – Translate values via reference tables
Why This Matters
Without SMART Migration, organisations face an impossible choice: abandon decades of documents and metadata, or remain locked into legacy systems indefinitely. SMART Migration makes the third option possible: migrate everything with full fidelity.
This capability is particularly valuable for:
- Organisations decommissioning legacy DMS platforms
- Compliance scenarios requiring complete content migration
- M&A situations where acquired company uses different DMS
- Government and regulated industries with long retention requirements
- Any situation where “the files are in a database somewhere”
—-
What SMART Migration Does NOT Migrate
| Content Type | Recommendation |
|---|---|
| Intranet pages / SharePoint Pages | Use IntraVox or xWiki |
| Email (Exchange mailbox) | Dedicated mail migration tools |
| Business logic / Workflows | Re-implement in Nextcloud Flow |
—-
Key Benefits Summary
For IT & Migration Teams
- Near real-time BI monitoring and analysis
- Job management through familiar SharePoint/Teams interface
- Deep file-level tracking and verification
- Parallel workstreams for large organisations
For End Users
- Seamless transition via proxy links
- No dual-editing conflicts
- Gradual migration with zero disruption
- Familiar click-to-open experience
For Finance & Management
- Immediate storage cost reduction (SharePoint: ~$2,400/TB/year)
- Data-driven planning and estimation
- 100% file accountability and compliance
- Clear progress visibility for stakeholders
For Content Owners
- Self-service content reorganisation in Workspace
- No more Excel-based planning nightmares
- Work in Teams channels with their specific content
- Make decisions about content they understand
—-
Proven Scale & Performance
Enterprise-Proven at Massive Scale
SMART Migration has been battle-tested in some of the largest migration projects undertaken:
- 250 million documents migrated in a single engagement
- 300,000 site collections processed
- Multiple high-profile, high-scale projects completed successfully
Parallel Execution Architecture
The decoupled architecture enables true parallel migration:
- Multiple migration servers can run simultaneously
- Multiple content owner groups work independently
- No single bottleneck (goodbye, overworked migration consultant!)
- Each Teams channel operates on its own timeline
- Scale horizontally by adding migration capacity as needed
Performance Optimisation
Performance depends on many variables (network, throttling, file sizes, version counts), but SMART Migration is:
- Super-optimised for throughput
- Extensively multi-tasked for maximum parallelism
- Designed to work within Microsoft’s throttling limits
- Tuned through years of real-world enterprise deployments
Comprehensive Logging & Error Handling
When issues occur (and in migrations at scale, they do), SMART Migration provides:
- Full trace logging for every operation
- Error events viewable in complete context
- Detailed diagnostics for troubleshooting
- Audit trail for compliance and verification
- Problem files identified and tracked for resolution
Software Maturity
SMART Migration is mature, stable, and thoroughly proven:
- Second major architecture rewrite completed in late 2020
- Five+ years of continuous refinement since rewrite
- Extensively tested across many enterprise deployments
- Hardened through high-profile, high-stakes projects
- Production-proven reliability at scale
—-
Deployment & Security Architecture
100% On-Premises – No Cloud Dependencies
SMART Migration is installed locally at the customer site for maximum security and data sovereignty:
- Runs on Windows 11 or Windows Server (physical or VM)
- All processing happens on customer infrastructure
- No data travels to external cloud services
- Complete air-gap capability if required
- Customer retains full control of all data at all times
Subscription Licensing
SMART Migration is licensed on a flexible subscription basis:
- Available in 1, 3, 6, 12, 24+ month terms
- Installed locally – license controls feature access
- Scale licensing to match migration timeline
- No per-file or per-GB pricing surprises
Teams Integration – Pure Out-of-the-Box
The Teams/SharePoint integration requires no custom development:
- No PowerApps components
- No Power Automate flows
- No custom Teams apps
- Built entirely on out-of-the-box SharePoint features
Setup is simple:
- Provide a blank Team with one or more channels
- SMART Migration automatically provisions all required lists and structures
- Multiple channels enable user separation (different content owner groups)
- Everything else is handled by the platform
This approach ensures:
- No additional licensing costs (M365 standard licenses sufficient)
- No maintenance of custom components
- Familiar SharePoint/Teams experience for users
- IT governance compliance – no shadow IT concerns
—-
Technical Characteristics
- Operates within Microsoft Teams environment – uses MS platform to exit MS
- Supports continuous work in source systems during migration
- Migration can span multiple years for large organisations
- BI and analysis runs decoupled from Teams and migration servers
- Phases are not sequential – parallel and overlapping timelines
- BI analysis is global; separate licenses required for separation
- Fully documented and secure process
- 100% on-premises deployment – maximum security
—-
Summary
SMART Migration fills a critical gap in the market by enabling organisations to migrate away from Microsoft’s ecosystem to Nextcloud while preserving what matters most: metadata, version history, and content governance. The revolutionary Workspace concept, zero-footprint proxy links, and comprehensive Power BI analytics make enterprise-scale migrations manageable, trackable, and successful. Unlike simple “lift and shift” tools, SMART Migration provides true content governance capabilities never seen before in migration tooling.