modernization from oracle to sql server
Advanced Engineering Application Modernization from Oracle to SQL Server
22 Apr 2019

As moats create obstacles in the way of an invader, so do proprietary database features for developers. One of Oracle’s proprietary features is the Oracle Call Interface (OCI) which provides efficient communication between application code and the database. There are other ways to connect to Oracle, but once you have committed to OCI, you are “protected” from switching to another database. In this blog post, we break down an application modernization from Oracle to SQL Server for an advanced engineering-oriented […]

A global leader in legal content management services migrates from Sybase to SQL Server
Migrate Sybase Java applications to SQL Server for content services provider
04 Oct 2018

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 system. We helped our customer in the past with a Sybase ASE migration. The challenge for this project — migrate Sybase Java applications along with the associated Sybase ASE and IQ database solutions to SQL Server running on AWS EC2. In this video blog post, we’ll […]

An automated solution for Crystal Reports conversion from Oracle to SQL Server
13 Aug 2018

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 presented a huge challenge to their migration effort. They reached out to DB Best to develop an automated way to convert all of the connection information from Oracle to SQL Server and, more importantly, develop an automated solution that can extract the Oracle PL/SQL statements in the reports, convert them to SQL Server […]

Faster, Cheaper, Better: Upgrade SQL Server 2008 NOW
17 Jul 2018

So Long, Microsoft SQL Server 2008 I think that you’re supposed to know when it’s time to say goodbye. – Judy Sheindlin We get it. You’ve been running your SQL Server 2008 for ten years now, and its performance has made you very happy. It’s been as steady as a rock and helped guide your business while keeping your data safe and you really can’t ask for a better show from your database software. Unfortunately, it’s now reached the end […]

Sybase ASE to SQL Server Database Unification Project
Using Sybase SQL Server application unification to reduce migration risks
14 Mar 2018

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. 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 on AWS EC2 instances. We came up with a way to create an identical […]

Expand capacity with an IBM DB2 SQL Azure SQL Database migration
09 Oct 2017

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 system lacked repository to host historical audit related data, so they could hardly retrieve data from past years. Then we came up with an Azure cloud database solution that could store all the historical data and created Power BI reports on top of it. We performed the IBM DB2 Azure SQL Database migration as a […]

How to determine Oracle migration ROI for complex systems
06 Sep 2017

A global pharmaceutical company has been supporting hundreds of applications on the Oracle platform. Their complex system became outdated over the years with 90% of end of life or extended support Oracle versions with very expensive contracts. They needed a cost effective solution, so they looked for a way to move their workloads to a higher value SQL Server solution. See how we helped our customer determine Oracle migration ROI (Return on Investment) for their highly complex environment. Let’s see how […]

Migration Project for A Global Leader in Security Technology
Migrate Sybase ASE databases to SQL Server for a security technologies company
25 Aug 2017

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 their out-of-support server instances, our customer needed a way to migrate hundreds of Sybase ASE databases. To make matters worse, our customer faced upgrading their out of support PowerBuilder applications. By migrating to SQL Server on commodity Intel based servers, our customer found that they could exceed their performance needs […]

Architecting highly available and scalable system when migrating to SQL Server
Architecting highly available and scalable system when migrating to SQL Server on AWS
12 Jul 2017

Our customer needed to reduce the licensing costs of their Oracle database. We came up with a comprehensive solution by migrating their database to SQL Server platform. We also remediated all affected application components. As a result, our customer benefited from obtaining higher value SQL Server platform with enhanced scalability and high availability approaches.

Delivering expert support in resolving database conversion errors
21 Jun 2017

One of the major United States universities has been migrating their complex data managing system from Sybase to SQL Server. They used SQL Server Migration Assistant for Sybase to automate the migration process. However, SSMA tool could not deal with 100% of their source code, and their development team required some assistance with a manual conversion. So they asked us to provide technical support in resolving these conversion errors. With our guidance and extensive support, our customer was able to complete the migration within the short […]