Cracking the code to successful conversions: Development, implementation and ongoing support


The last three parts of our conversion blog (see all of the posts here) go hand-in-hand and require the most time on the project plan.

Development - During development of the conversion routines, you may want to consider using error handling standards based on corporate standards. This is where data profiling can really help out. There is nothing worse than running thru 3 million rows of conversion records and hitting a snag with data that did not convert properly.

Please, do not change the database to allow the errors in the data. It will just make life harder later on. Instead decide how to conform, and convert the data based on our new application, and consider data profiling as your friend.

Implementation - Implementation should be completed multiple times. Some companies require three cutover to production practices before final implementation.

I like this approach, but it must be well thought out, data needs to be in the right environments, and every one of the team member on board and ready to work based on the rollout plan. Consider a post-implementation review after each cutover practice.

Ongoing Support – Yes, this application will require on-going support. This is hard for quite a few companies that are project oriented. You still need a team for on-going changes, enhancements and fixes. I like to keep the "fix-it" team intact for a few weeks after cut-over to production, just in case there are any issues.

Well, happy conversions, and I look forward to our new format for 2015!


About Author

Joyce Norris-Montanari

President of DBTech Solutions, Inc

Joyce Norris-Montanari, CBIP-CDMP, is president of DBTech Solutions, Inc. Joyce advises clients on all aspects of architectural integration, business intelligence and data management. Joyce advises clients about technology, including tools like ETL, profiling, database, quality and metadata. Joyce speaks frequently at data warehouse conferences and is a contributor to several trade publications. She co-authored Data Warehousing and E-Business (Wiley & Sons) with William H. Inmon and others. Joyce has managed and implemented data integrations, data warehouses and operational data stores in industries like education, pharmaceutical, restaurants, telecommunications, government, health care, financial, oil and gas, insurance, research and development and retail. She can be reached at

Related Posts

Leave A Reply

Back to Top