Converting Oracle system functions to PostgreSQL with AWS SCT extension pack
16 Nov 2020

Migrating Oracle databases to PostgreSQL on AWS, you often face challenges with converting system functions. Oracle has a rich set of built-in functions, and PostgreSQL doesn’t provide users with all of those. To support and simplify Oracle to PostgreSQL on AWS migrations, AWS Schema Conversion Tool provides users with an extension pack. After applying it to your Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL database, you may use the functions, which emulate the behavior of Oracle’s system functions. You […]

Top customers’ stories on AWS
03 Aug 2020

Last updated in August 2020 The goal of DB Best blog is to deliver technical content on various completed projects and researches. Publishing over 100 blog posts per year, we pay great attention to the projects, related to the cloud data platforms in general, and Amazon Web Services (AWS) in particular. Some of the AWS customers’ stories attract more attention than others, so, that’s why we decided to collect them in one place. We consider these articles must-read and super […]

Top AWS DMS and SCT blog posts
03 Aug 2020

Last updated in August 2020 Sharing our technical experience with the readers, we’ve reached a pretty impressive audience on our blog. So, it was pretty easy to distinguish the most popular AWS Database Migration Service (AWS DMS) Support stories. Let’s jump right in and review the most valuable and really important DB Best blog posts on AWS DMS and AWS Schema Conversion Tool (AWS SCT). We’ve got an impressive series of blog posts, where we talk about the features of […]

Oracle to PostgreSQL migration tool
Comparing Ora2Pg with АWS SCT for Oracle to PostgreSQL migration
18 May 2020 , Bill Ramos

AWS Schema Conversion Tool (SCT) and Ora2PG allow for automating database migration from Oracle to PostgreSQL. Which tool would you prefer to use in real migration project for enterprise accounts? Read this blog post to find the answer.

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

migrate Apache Cassandra to Amazon DynamoDB
Using AWS Schema Conversion Tool to migrate Apache Cassandra to Amazon DynamoDB
19 Feb 2019

Looking for greater flexibility, speed, and scale for your Apache Cassandra solutions? It’s time to consider Amazon’s DynamoDB as a great alternative. We would like to share our hands-on experience and insights for those looking to migrate Apache Cassandra to Amazon DynamoDB using the new data extraction agents that AWS recently released with the Schema Conversion Tool. This migration approach involves adding an additional datacenter to an existing Cassandra cluster. This datacenter clones all data from the original cluster, and […]

migrating PostgreSQL to Amazon RDS Aurora
Improve PostgreSQL Performance 12X by Migrating to Amazon Aurora with Minimal Downtime
17 May 2018

An online marketplace company managed a 6-terabyte database using an old version of Amazon RDS PostgreSQL version 9.3. With their platform gaining popularity day over day, they needed a way to scale the performance and size of their database near term to 15-terabytes. They also had several performance issues, including a daily batch script that was taking almost 2 hours to complete that was exceeding the maintenance window. Because of this, simple tasks like adding a new column to their […]

AWS Schema Conversion Tool
Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
19 Jun 2017

In Oracle you may use the conditional insert clauses, for example, an INSERT ALL statement to add multiple rows with a single command. You can insert rows into one table or even multiple tables using just one SQL statement in Oracle. However, PostgreSQL doesn’t support such statements that attempt to inserting multiple rows. So, when you try to convert the source Oracle code that includes the INSERT ALL statement to PostgreSQL in the AWS Schema Conversion Tool, it will generate the following […]

Oracle to PostgreSQL database migration and unification project
Using PostgreSQL in cloud alongside with Oracle to enhance the database system performance
15 Jun 2017

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 AWS RDS to their original system and upgrade the connected Java application to support both database platforms. We came up with a proof of concept and converted one of the largest customer’s database schemas to PostgreSQL, demonstrating how the upgraded system might work. To do so, we updated the application by adding […]

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