convert Oracle synonyms to PostgreSQL
How to convert Oracle synonyms to Amazon RDS for PostgreSQL
15 Apr 2019

One of our ISV customers wanted to get off their expensive Oracle licenses and develop a cloud-based SaaS solution. They looked to us to help their development team migrate their database applications to Amazon RDS for PostgreSQL . The DB Best migration team utilized AWS Schema Conversion Tool (SCT) to automate the conversion of customer’s database and application code. However, the original system utilized a lot of specific Oracle features, for example, synonyms. SCT does not convert all types of Oracle synonyms […]

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 […]

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 […]

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 […]

Oracle to Azure SQL Database shift may save up to $1 million
16 Jun 2017

‘Low-performing and costly’ — these were major characteristics of the Oracle system of one of our customers, a leading US automotive corporations. In this regard, it was quite natural for them to consider migrating to another database platform. We suggested changing their Oracle Database to Azure SQL Database and moving their applications to Azure services. However, the customer may well anticipate this Oracle to Azure migration solution. Why? Because according to the calculations made by our experts, they can save […]

Taking advantage of Always On Availability Groups while upgrading your SQL Server
12 Jun 2017

One of the largest US national credit unions needed to upgrade their obsolete SQL Server database to take advantage of the latest Always On Availability Groups offerings. We came up with a database upgrade solution that included re-architecting of the customer’s applications. In the end, our customer started using a truly high availability database system while improving its failover features. Learn more about the technical issues of this upgrade project from the following video.

Comprehensive Java app upgrade while migrating to SQL Server
Comprehensive Java app upgrade while migrating to SQL Server
08 Jun 2017

One of the largest transportation companies in the United States needed to migrate their Oracle-based application to SQL Server platform. The customer’s application code had high query complexity which increased the level of difficulty for our automated tools. In order to overcome this challenge, we performed manual conversion of the embedded SQL code along with application upgrade to the latest Java version. The customer didn’t have the time, resources or expertise to modernize and migrate their many hundreds of business critical […]

Using AWS Schema Conversion Tool for Application Conversion
24 Feb 2017

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 interacting with the source database. To wrap up the database migration project, you will need to convert the SQL code used in the application and then reconnect it to the new database. AWS Schema Conversion Tool (SCT) helps to automate this process and simplifies required efforts estimation for manual SQL code conversion. Check the […]

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

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 migration proof of concept project for a government organization in South America. What made this project unique was the way we used SQL Server Migration Assistant (SSMA) to convert one of eleven Oracle database schemas that were running on a 12-node Oracle RAC cluster to SQL Server. The […]

Running Any Of The Following ISV Applications On Oracle Or Sybase? You Might Qualify For A Free 3 Day Migration Workshop!
30 Mar 2015

You are running any of the following applications on Oracle or Sybase, and you are wondering what it would take to get them migrated to SQL Server? Well you probably qualify to join us for a by-invitation only 3 day hands on workshop with leading technical experts, prior to MS Ignite, at zero-cost* to you. So if you are running: Team Center, PTC, Sungard, Kronos, SAP on a non-SQL Server platform, contact us and apply to take part in the […]