Getting Started

To get started migrating your on-premises databases to AWS, we recommend considering our Future-State Architecture Design Engagement to better understand your current situation and create a roadmap for your future solutions based on AWS technologies.

For SQL Server migrations to the AWS RDS platform, we recommend our Data Management Optimization offer, where we capture performance metrics of your on-premises databases and use that data to make specific recommendations on instance types to save costs and maximize performance.

If you just need a hand getting the most out of AWS Database Migration Service (DMS) or Schema Conversion Tool (SCT), we also have our jumpstart-support offer.

Learn more about our main offers below.

Innovative solutions using AWS DMS and SCT

One of the leading independent education software vendors sought 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 created a proof of concept and converted one of our customer’s largest database schemas to PostgreSQL, demonstrating how the upgraded system may work.

 

To do this, we updated the application by adding unified SQL code and changing its architecture to support two database platforms. As a result, the newly created system could meet the customer’s performance requirements.

Watch the following video to learn more about the technical approach which included the use AWS SCT that we’ve used for code migration and unification.

Let's get together to talk about AWS Database Migration Service
Contact us today

Migrating OLTP and Data Warehouse solutions using the AWS Schema Conversion Tool

Whether you are running online transaction processing (OLTP) or data warehouse workloads, we know the ins and outs of migrating databases, moving data with DMS, and migrating application code using SCT. Here are some examples of data migration scenarios we support.

Contact us today to help you with AWS Database Migration Service
Contact us

Learn More

Check out our great blog posts highlighting various scenarios using AWS Database Migration Service and Schema Conversion Tool; taken from real life situations experienced by our customers migrating their databases to Amazon Aurora, AWS RDS, and Amazon Redshift.

Blog posts

Using AWS Snowball Edge to transfer multiple terabytes of data into the Amazon cloud
10 January 2018 admin

One of the main concerns during large-scale database migrations to the cloud is how long will the data transfer last. When you need to move multiple terabytes of data, the migration pr...

Top AWS DMS and SCT blog posts
8 February 2018 Andrey Ivanov

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

AWS Schema Conversion Tool: Applying Converted Code to Target Database
16 November 2016 Bill Ramos

This continues our video blog series on the AWS Schema Conversion Tool (SCT). After connecting to the source database and troubleshooting the database migration issues it’s time to a...

AWS Schema Conversion Tool: Connecting to Oracle Source Database
13 September 2016 Bill Ramos

In this video blog post, we will walk through the various Oracle database connection options using the AWS Schema Conversion Tool as the source database. The AWS Schema Conversion Tool...

AWS Schema Conversion Tool: General Approach to Migration of Data Warehouses to Amazon Redshift
6 December 2016 Bill Ramos

This post continues our video blog series on the AWS Schema Conversion Tool (SCT). In our previous blog posts, we talked about using AWS SCT for transactional database migration projec...

AWS Schema Conversion Tool: Offline mode
30 August 2016 Bill Ramos

This continues our video blog series on the AWS Schema Conversion Tool (SCT). We will demonstrate how the AWS Schema Conversion Tool allows users to work with saved projects in offline...

AWS Schema Conversion Tool: Specific Features of Migrating Data Warehouses to Redshift
14 December 2016 Bill Ramos

This continues our video blog series on the AWS Schema Conversion Tool (SCT). In the previous blog post we’ve talked about the general approach of data warehouses migration to Amazon...

Converting Objects during Database Migration using AWS Schema Conversion Tool
11 October 2016 Bill Ramos

This continues our video blog series on the AWS Schema Conversion Tool (SCT). We will demonstrate how the AWS SCT helps users convert data and code objects from Oracle database to AWS ...

Database migration with AWS SCT: How to handle typical conversion issues series
2 March 2017 Bill Ramos

Welcome to our blog post series covering the typical conversion issues of AWS Schema Conversion Tool (SCT). DBBest team has a vast experience in database migration area. So, we decide...

Database migration with SSMA: How to handle typical conversion errors
9 March 2017 Bill Ramos

Welcome to our blog post series covering the typical conversion errors of SQL Server Migration Assistant (SSMA). DB Best has a vast experience in database migration, so, we constantl...

Extracting Data from Warehouses with Data Migration Agents in AWS Schema Conversion Tool
15 March 2017 Bill Ramos

Migrating data warehouses to Amazon Redshift represents a serious challenges when you consider what it takes to transfer huge amounts of data in parallel. On February 16, 2017, Amazon ...

First look at AWS Schema Conversion Tool with tighter DMS integration
3 January 2017 Bill Ramos

On December 20 2016, Amazon released version 1.0.502 of AWS Schema Conversion Tool (SCT). SCT now provides the integration with Data Migration Service (DMS)  and allows you to create ...

Migrating an Oracle to MySQL Database using the AWS Schema Conversion Tool
23 August 2016 Bill Ramos

Welcome to the very first blog post on getting started with the AWS Schema Conversion Tool (SCT). This is the first video in a series of many where we’ll help familiarize our readers...

Optimizing your Redshift Storage with AWS Schema Conversion Tool
2 March 2017 Bill Ramos

Amazon introduced the new feature called Redshift Optimization for the Schema Conversion Tool (SCT) November 17, 2016 release. You can now use AWS SCT to optimize your Amazon Redshift ...

Oracle to MySQL migration with AWS SCT: How to convert BULK COLLECT clause
16 March 2017 Bill Ramos

Oracle’s SELECT INTO statement with BULK COLLECT clause allows you to retrieve an entire result set and store it in a PL/SQL collection type variable in a single operation. This appr...

Oracle to MySQL migration with AWS SCT: How to convert variables of SYS_REFCURSOR datatype
2 March 2017 Bill Ramos

Oracle 9i introduced the predefined SYS_REFCURSOR type meaning we no longer have to define our own REF CURSOR types. We normally use Oracle’s SYS_REFCURSOR datatype to declare the CU...

Oracle to MySQL migration with AWS SCT: How to handle unsupported NumToYmInterval function
2 March 2017 Bill Ramos

Oracle’s NumToYmInterval function converts the provided number value of specified time units or expression to an interval year to month literal. Usually, we use the interval values w...

Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
19 June 2017 Andrey Ivanov

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

Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported data types
2 March 2017 Bill Ramos

Oracle’s subtype declaration allows creating an "alias" for some datatype declaration, which can be re-used later as many times as needed. PostgreSQL domains do not match Oracle's su...

Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported NumToDSInterval function
2 March 2017 Bill Ramos

Oracle’s NumToDSInterval function converts the provided number value of specified time units or expression to an interval day to second literal. Usually, we use the interval values w...

Selecting target database type for migration using Assessment Report in AWS Schema Conversion Tool
20 September 2016 Bill Ramos

This continues our video blog series on the AWS Schema Conversion Tool. This post covers one of the key features of the application: the Database Migration Assessment Report. The Asses...

Troubleshooting database migration issues using AWS Schema Conversion Tool Assessment Report
27 September 2016 Bill Ramos

This continues our video blog series on AWS Schema Conversion Tool. In our previous blog post Selecting target database type for migration using Assessment Report in AWS Schema Convers...

Using AWS Schema Conversion Tool Extension Pack for OLTP databases
23 March 2017 Bill Ramos

Running your database migration projects, you may have already noticed that AWS Schema Conversion Tool (SCT) automatically generates an additional schema called extension pack. This sc...

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 data extraction agents to fulfill the database migration projects in AWS Schema Conversion Tool
7 June 2017 Andrey Ivanov

The Amazon Database Migration Service (DMS) does a great job in helping to copy data from your on-premises databases to AWS RDS for OLTP workloads. When you start talking about terabyt...

Using data extraction filters for smart database migration with AWS Schema Conversion Tool
29 June 2017 Andrey Ivanov

Amazon introduced the data extraction agents in the previous release of AWS Schema Conversion Tool (SCT). They allowed for migrating all the data from your on-premises data warehouse p...

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

Fast and error-free migration to the AWS cloud
6 June 2017 Stanislav Andrenko

A major data processing company has been supporting on-premises system with an application that handles document flow from several local printers. They needed to leave their current da...

Reference data sheet

Amazon Web Services Migration
17 November 2016 Bill Ramos

DB Best Technologies is internationally known for comprehensive Data Management Services, database development and migration, and the creation of highly successful web and mobile syste...

Data Management for Amazon Web Services
8 November 2016 Bill Ramos

DB Best Technologies is internationally known for comprehensive Data Management Services, database development and migration, and the creation of highly successful web and mobile syste...

Data Management Optimization
22 August 2016 Bill Ramos

DB Best has  five key areas we focus on when proposing our customized modernization map. Our data-centric approach involves an in-depth look at your organization's data platform so w...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote