The core offerings of our business are database conversion and database migration. We have implemented numerous database conversions, migrations, and modernizations so far. We know that all database migrations have to be connected to application code and need to be addressed holistically. Very often, the database modernization effort triggers a necessity to modernize an old application.

We have a solid understanding of the common challenges you are likely to face while implementing such projects. Whether it comes down to targeting a single application, a family of apps, or  a full portfolio, we have seen it all and can choose the right path based on our experience.

Let’s take a look at some typical challenges in application modernization projects:



Converting SQL statements

First, we extract all the SQL statements from the source application code. We use our in-house automated tools for SQL code extraction. Then, we convert the extracted statements to make them compatible with the new database platform. We use our automated conversion tools, such as SQL Server Migration Assistant, AWS Schema Conversion Tool, and DB Best Migration Platform, or in some cases, we use our experience to perform the manual conversion. Then, we apply the converted code to the source application files and compile the project, building the new application.

SQL code unification

Chances are the customer may need to support both old and new database systems for a certain period of time. In that case, we need to unify the SQL code in such a way that it can be interpreted by two database engines. To do so, we analyze the extracted SQL code and classify the code into one of the categories below

  1. Doesn’t require modification and can be executed against both database platforms without conversion;
  2. Requires unification to be used with both databases afterward (for example, we can use ANSI SQL standard);
  3. Can be automatically converted using specific conversion tools;
  4. Requires manual conversion and should be duplicated in the application.

In the end, you can run the application against both old and new database platforms.

Moving the application to the cloud

We know all the ‘gotchas’ and all the issues that may occur while moving the database application to any modern cloud database platform. Also, we can help you discover the right path to building the new architecture for your application running in the cloud. We can craft the new system, using specific web services for that particular cloud platform.

Rewriting the application to optimize it for the new database platform

It is often more cost-effective to rewrite the application to gain the performance and flexibility that you require. DB Best has deep knowledge of all major development tools and frameworks, from Desktop to Web to the Cloud, we can easily find the most effective application modernization solution to take full advantage of the new platform.

At the end of the day you may be looking for a proven solution to test your new application. Consider using the DB Best Migration Platform to automate this task.

Learn more about Application Modernization
Contact us


Our company started from developing a database migration technology. Over the years we’ve built multiple conversion automation tools and performed hundreds of database migration projects. During this process we developed a comprehensive 12-step migration methodology, which became an industry standard.

In all of these projects we start from the database, but very quickly get to application re-platforming or application modernization topics. At the end of the day, the customers want to see their applications running on the new database platform. Oracle Forms modernization is a classic example of this kind of project, and DB Best has a proven automated solution to guide you to the Web 2.0 architecture in a matter of months.

During the database migration project, you need to convert all the database objects. At the application level, you need to adjust application code, interfaces and sometimes completely rewrite the business logic.

Usually, the application modernization requires a lot of manual work, there’s no easy way to convert applications using a single click.

We have a variety of offers to help you get the most out of your application running on your new database platform, making it compatible with all the latest features of the modern on-premises or cloud platforms.


A financial service software provider needed to upgrade their customer-facing applications to SQL Server while keeping their Sybase ASE database. Our Sybase SQL Server Application Unification process allowed them to use SQL Server as a new database engine.
We came up with a way to create an identical version of their existing Sybase ASE database running in SQL Server environment and performed some code unification that allowed the Power Builder front-end application to interact with both databases. Thus, the customer’s system now meets the rigorous high availability and encryption industry standards.

Customer Problem
Our customer needed to support both Sybase ASE and SQL Server databases in parallel, keeping the upgrade path for this complex system in the future.

The customer wanted to unify the PowerBuilder application so that it can interact with both Sybase ASE and SQL Server databases. Unification of a complex system that includes two or more database environments is a common task for product evolution. The modern market demands force customers to upgrade from old database environments, but very often they need to keep the original system running as well.

Using SQL Server allowed our client to meet regulations that required high availability features such as Always-On along with Transparent Data Encryption to secure their financial data.
The following video shows how we used this innovative Sybase SQL Server application unification approach to meet our customers’ requirements.

Let's get together to talk about Application Modernization
Contact us today


amazon web service
GCP logo


If you want to learn more about how DB Best application modernization projects, check out these great resources.

Blog posts

Challenges migrating SAS solutions to SQL Server - Missing Values versus NULL
28 January 2020 Bill Ramos

Managers for a well-known accounting and tax-preparation company contacted DB Best looking for an alternative solution to a big problem. They were long term customers of SAS but were n...

Migrating an On-Premises SAS System to Microsoft Azure HDInsight
26 November 2019 Katerina Yukhno

A global retailer in the beauty industry contacted DB Best looking for the right modernization path for their SAS based BI solution. They were hitting the boundaries of SAS with their ...

Converting embedded Oracle PL/SQL code to C# with an automated converter
9 September 2020 Andrei Ivanov

Our customer, a global provider of risk management products and services, was looking to reduce maintenance costs by migrating their international Oracle application to Azure. Their so...

An automated solution for Crystal Reports conversion from Oracle to SQL Server
13 August 2018 Andrei Ivanov

One of our customers decided to modernize their Oracle database to Microsoft SQL Server. However, the thousands of SAP Crystal Reports connected to their existing Oracle database prese...

Using PostgreSQL in cloud alongside with Oracle to enhance the database system performance
15 June 2017 Andrei Ivanov

One of the leading independent software vendors in educational domain needed to expand their original Oracle database system. They wanted to add a new PostgreSQL database running on AW...

Increasing database performance by migrating from Ingres to SQL Server
18 July 2017 admin

One of our customers needed to migrate their Ingres Database system to Microsoft SQL Server wanting to improve the performance of their system. We came up with a migration solution ...

Reduce the cost of an Oracle database migration project by using SQL Server Linked Servers
21 December 2016 Bill Ramos

When talking about migration from Oracle to SQL Server, we always look for ways to work with our customers to keep costs under control. We recently completed an Oracle to SQL Server mi...

Migrate Sybase Java applications to SQL Server for content services provider
4 October 2018 Bill Ramos

A leading provider of content services for the legal industry looked to DB Best to help them modernize their aging Sybase ASE and IQ solutions that were built on top of an old IBM AIX ...

Using AWS Schema Conversion Tool for Application Conversion
24 February 2017 Bill Ramos

A typical database migration project includes not only the schema conversion and data migration but also the application remediation. We are talking about one or many applications inte...

Using Sybase SQL Server application unification to reduce migration risks
14 March 2018 Bill Ramos

A financial service software provider needed to upgrade their customer-facing applications to SQL Server while keeping their Sybase ASE database. Our Sybase SQL Server Application Unif...

Migrate Sybase ASE databases to SQL Server for a security technologies company
25 August 2017 Bill Ramos

DB Best recently completed a project to migrate Sybase ASE databases to SQL Server for a global leader in security technology. Faced with skyrocketing license costs with SAP to renew t...

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...

Migrating Oracle database to SQL Server for a leading US healthcare company
17 March 2017 Andrei Ivanov

One of the leading US healthcare organizations needed to upgrade their health record system in an effort to drive down costs while enabling new capabilities. We proposed to migrate the...

Introducing the all-new Oracle Forms Converter
2 July 2019 Vladislav Tomashov

A public sector organization from the US faced a problem with an outdated Oracle Forms-based solution. They had thousands of users but couldn’t keep the existing system running at an...

Modernizing your outdated Oracle Forms using an automated Oracle Forms Converter
6 November 2019 Irena Balin

At the PASS Summit 2019, DB Best introduced a completely reworked Oracle Forms Converter, which is designed to automate conversion from legacy Oracle Forms to a modern Web 2.0 architec...

Using the Assessment Tool to estimate your Oracle Forms modernization project
27 November 2019 Andrei Ivanov

A lot of our customers are stuck with legacy Oracle Forms. Looking for better performance, our customers want to get off their outdated solutions and run their modernized forms in any ...

Windows Server 2008 — End of support
23 January 2020 Keith McCammon

January 14th, 2020. What does this date mean for your organization? More so than with SQL Server, falling out of support for Windows Server will have immediate consequences to the secu...

Creating a CI/CD solution for the database unification project
24 January 2020 Olga Ievdokymenko

Being an independent software vendor with a pile of applications written decades ago and a huge database in Oracle, our customer wanted to upgrade their software and make it more acces...

Applying CI/CD for deploying data-driven applications after migrating from Oracle to Amazon Aurora PostgreSQL
14 February 2020 Andrei Ivanov

When it comes to database migrations, application conversion/remediation along with functional testing of the entire system account for over 50% of the total effort. By using a proven ...


Modernizations to Microsoft's Data Platform
21 September 2016 admin

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...

Oracle to SQL Migration
21 September 2016 admin

Leveraging Microsoft SQL Server, DB Best can help Oracle customers achieve the performance, scale, and security that their mission-critical applications require while keeping costs und...

Modernize Your Data Estate Datasheet
19 February 2019 admin

Read our Modernize Your Data Estate datasheet to discover the benefits of our free assessment offer. Learn how DB Best can help with your on-premises modernization and cloud migration...

Case Studies

Restructuring a mobile advertising app
18 August 2016 admin

Our client, a mobile advertising company, had built an ad-placement app that allowed users to track many statistics related to their advertisements. Unfortunately, the app was not buil...

Migrating critical apps from Sybase ASE to SQL Server
30 August 2016 admin

Our client, a global leader in security technology, had two mission-critical yet aging PowerBuilder applications running against Sybase ASE that were out of compliance given the lack o...

White papers

eBook: Database Migration
9 August 2018 admin

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