Clean up your metadata and files before you start, not one by one as you hit them in the migration.
With our automated tools we usually find a few hundred corrupt or missing files in every million documents, and dozens of documents without “required” metadata. That’s two or three issues in every 10,000 documents – hardly noticeable day to day, but a lot of extra work fixing them one by one as they come up in the migration, possibly even crashing it. It’s much easier to identify the common issues and fix them in one hit before you start.
Our tools and methodologies (available when we work with you) systematically and logically minimise the issues that come up in the actual migration.
We’ve used our tools and methodologies mostly on SQL Server based systems like DOCs Open, DM6, IManage, Worksite, Content Server, FileNet, SharePoint, but also a little with Oracle CMS.
Tools for CMS migrations
Generally speaking, tools for document data migrations should be able to run on older PCs and servers, and have very low impact so that usage on different PCs or servers doesn’t require a lot of memory, or necessitate a lot of change control.
Thus our tools use the minimum Dot Net Framework version for the task (ok, we draw the line at 2.0 as a minimum), and generally can be run from a folder, or even a USB stick, without installation.
If you employ us on a job we come with our toolkit, but in 2012 we’ve been getting some of our tools in shape for commercial release. Below are some of our tools, with links to those that are released or in beta release.
- Metadata and security analysis methodologies and tools
- Find missing or zero byte files – useful at all times for checking a document store. Check all files or a selection of files, and report on the number and size of the files.
- Extract just the files you are migrating so they can be migrated without touching the live system, and also so you don’t need to find space for a full copy of your file store.
- Add file extensions, insert placeholders for missing or zero byte files.
Windows file system import assistant – read all the files in a Windows folder structure into a database table (including properties) ready for import into your system of choice (SharePoint, etc)