Three Best Practices: Modernizing
Mainframe DB2 to SQL Server

db2 to sql server

A broad view of organizational data is vital for management reporting, business intelligence, analytics, and decision support.  But what happens when critical data from important lines of business is locked up in a legacy DB2 system, technically incompatible with modern data management solutions that hinge on Microsoft technologies? While assessing options, always remember: When migrating Mainframe DB2 to SQL Server, the devil's in the details.

Three Best Practices for Modernizing Mainframe DB2 to SQL Server

In our experience, this scenario is more common than you might think.  Luckily, over the years we've developed some best practices that can ease the transition.


While the DB2 to SQL Server transition is anything but like-for-like, there are going to be far more similarities than differences between the source and target architectures. Design the target database layout with the functional aspects of the source in mind. Create required objects with the same name and data types as source objects. This creates familiarity and ease of querying without the need to learn new mappings and reduces time to productivity when Mainframe DB2 is decommissioned. It may pay dividends to establish patterns or reuse existing best practices like parent-child package executions, execution control via configurations, and final execution from SQL Agent as opposed to direct package execution from third parties, package templates, etc.

Development Considerations

An extension of smart architectural considerations, development best practices can make a huge difference when migrating Mainframe DB2 to SQL Server. Whether you're implementing new and more efficient standards in the target environment or even converting DB2 timestamps to equivalents in SQL Server, keeping the development environment that will be administered against the new SQL Server database will save tons of time and headaches down the road.

Implementation & Maintenance

It is vastly important to keep the services that depend on the database in mind during the migration process. Taking DB2 to SQL Server isn't simply about a conversion exercise, it is about migrating to a modern environment that can more easily and more efficiently interact with other business critical services. Liberating legacy data for consumption in modern BI systems is an exciting endeavor, but don't let it eclipse the importance of interoperability with other less exciting systems that rely on the data you're migrating to operate day-in and day-out.

Companies of all sizes are grappling with aging, complex systems that are costly to maintain and too inflexible to support new business initiatives.
Most vendors are more concerned with selling new systems than helping to retire old ones. It can take a lot of effort to move data off the old system, archive the application’s data, and decommission the supporting infrastructure. It can be a challenging project, but with a little help and a few pointers, it doesn't have to be impossible.

Share This

Share This

The world needs to know more about modernization. Help us spread the word!