Why migrate?

Compared to IBM DB2, Microsoft SQL Server provides better security, developer productivity, manageability, and also delivers on its promise to lower Total Cost of Ownership (TCO). Microsoft SQL Server provides out-of-the-box support for transparent data encryption, master data management, and self-service business intelligence. On the other hand, all these features are all expensive add-ons from IBM.

DB Best can provide you with a turnkey migration solution to Microsoft SQL Server.

Typical challenges that we see

Database migration is a daunting task with a lot of hidden issues and possible problems. With our extensive experience, we can overcome database migration challenges that you could face when you start to migrate IBM DB2 to SQL Server.

First of all, your IBM DB2 source code may include specific queries, which you need to replace with T-SQL equivalents. The DB Best team knows how to automate this conversion in order to make both database and application code compatible with SQL Server.

Also, before starting the migration, you should have a good understanding of your database workload including any key performance metrics and frequency of peak loads. The key to a proper comparison is a way to replay a workload. For example, you can do this through the SQL Server Distributed Replay feature or your own load harness.

Once under load, you can evaluate your new technology by monitoring pressure on CPU, Memory, IO Operations, and network traffic. By monitoring when the system is under pressure, the DB Best team can help determine if your technology is properly sized or if resources need to be adjusted. To do so, the DB Best engineers can take advantage of our in-house DBMSys Platform as a part of our data management optimization offer.

DB Best can help you profile your existing environment and then grade your migration against that profile. Even if you choose to move your IBM DB2 workloads to the cloud, be sure to rely on our experienced team.

Learn more about migrating IBM DB2 to SQL Server
Contact us

The leader in IBM DB2 to SQL Server migrations

The DB Best team developed a unique methodology for migrating IBM DB2 applications to Microsoft SQL Server. This technology has been tested and proven many times over with hundreds of different customers. Being an architect and the original creator of SQL Server Migration Assistant (SSMA), the DB Best team is THE database migration expert you can trust with your project.

Find the DB Best tools that we’ve developed to optimize the IBM DB2 to SQL Server migration process below.

Based on our vast migration experience, the DB Best team developed our in-house products Database Compare Suite and DB2 Migrator, which greatly complements SSMA for IBM DB2.

You can also rely on our Migration Platform to guide you through the migration process, automate the migration verification and application testing.

Getting started

Sometimes you need a helping hand to get you started. So, here are some of our offers to help with assessments, using SSMA, or developing a future-state roadmap.

Improve application performance with a move from DB2 to SQL Server

One of our customers supported a DB2-based reporting application. Their system included Java based web app and Informatica data management solution connected to DB2 databases. So, to provide a web interface for reporting needs they deployed a WebSphere server for hosting their Java application. With this interface, a small circle of users could create reports using data imported via Informatica.

Our customer wanted to reduce the maintenance costs and increase functionality. So, we came up with a solution to migrate IBM DB2 to SQL Server databases. Then we reconnected the application to the new database.

See how we migrated an application to the Microsoft SQL Server platform in the following video.

Let's get together to talk about migrating IBM DB2 to SQL Server
Contact us today


Data integration tools play a big part in the successful migration of IBM DB2 databases to SQL Server. Ideally, you will want to minimize the changes to your data integration processes. We have extensive experience in the following platforms.

Supporting your SQL Server solutions after the migration

As part of our migration project, we offer training, support, consulting, and managed services for your SQL Server solutions. Obviously, you don’t want to go through the hassle of maintaining the day-to-day operations of your databases and applications? If not, be sure to check out our Operational Data Management service.

Contact us today to help you Migrate IBM DB2 to SQL Server
Contact us

Learn more

We have a great set of blog posts and data sheets to help you better understand our capabilities as the leader in database migration services. Take a look at our expertise in moving IBM DB2 workloads to Microsoft SQL Server and Microsoft SQL Azure.

Blog posts

Improving the web app performance while migrating from DB2 to SQL Server
4 May 2017 admin

One of the largest life insurance companies in the United States supported a reporting application. Their system included Java based web app and Informatica data management solution c...

Database Compare Suite update 4.11 with Vertica Analytics Platform support
4 September 2017 Andrei Ivanov

We’re happy to announce the latest release of DB Best Database Compare Suite. The new version marked 4.11 brings support for Vertica Analytics Platform. Learn more about the ultimate...

Expand capacity with an IBM DB2 SQL Azure SQL Database migration
9 October 2017 Andrei Ivanov

One of the world’s largest distributors of non-food consumable products wanted to rationalize their data platform and business intelligence strategy. Their current IBM DB2 database s...


Modernizations to Microsoft's Data Platform
21 September 2016 Bill Ramos

Cloud services such as Microsoft Azure, coupled with database technologies like SQL Server, enable organizations to quickly create and scale solutions that solve challenges and fuel ne...

Database Modernization for Microsoft Technologies Datasheet
3 September 2019 Bill Ramos

Read our Database Modernization for Microsoft Technologies datasheet to find out the details of our database modernization offer. We possess the in-depth understanding of database and ...

White papers

eBook: Database Migration
9 August 2018 Bill Ramos

DB Best goes well beyond other migration service providers. We take a vested interest in your migration strategy, combining innovation with an accelerated ROI that meets your business ...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote