13 August 2018 Andrey 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...
TYPICAL CHALLENGES THAT WE SEE
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 chose the right path based on our experience.
Let’s take a look at some typical challenges in application modernization projects:
Converting SQL statements
Conversion of SQL statements to execute against the new database platform
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 and AWS Schema Conversion Tool, 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
Making the application compatible with both old and new database platforms
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
• Doesn’t require modification and can be executed against both database platforms without conversion;
• Requires unification to be used with both databases afterward (for example, we can use ANSI SQL standard);
• Can be automatically converted using specific conversion tools;
• 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. 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.
Learn more about Application Modernization
ppo[p[i ;lkj;lp;op ;lkjljp;looi j;popoipoip
GETTING STARTED OFFERS
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.
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.
HOW WE UNIFIED APPLICATION TO SUPPORT SQL SERVER AND SYBASE
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.
Benefits
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.
Contact us today
OUR PARTNERS
LEARN MORE
If you want to learn more about how DB Best application modernization projects, check out these great resources.
Blog posts
An automated solution for Crystal Reports conversion from Oracle to SQL Server
Using PostgreSQL in cloud alongside with Oracle to enhance the database system performance
15 June 2017 Andrey 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 2016 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 2017 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...
Moving Oracle Forms to The Web as a Part of Database Migration Project
16 May 2017 Andrey Ivanov
A government healthcare organization wanted to move their Oracle Forms to a modern web-based UI. We offered to migrate their source Oracle database to SQL Server while converting the d...
Improving the web app performance while migrating from DB2 to SQL Server
4 May 2017 Stanislav Andrenko
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 Stanislav Andrenko
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 replaced the customer's...
Reference data sheet
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...
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...
Reference white paper
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 ...
Request a quote