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...
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.
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
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
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...
Deploying Windows IIS and SQL Server on AWS with CloudFormation
16 August 2018 Bill Ramos
In order to modernize their existing applications, databases, and infrastructure, a major state-run university with nine campuses, approached DB Best with a desire to not only create t...
Best practices for moving SQL Server to AWS: Amazon EC2 and RDS
26 July 2018 admin
One of the world’s largest multimedia content providers was looking for a way to increase the level of user satisfaction by improving the performance of their enormous database syste...
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...
Request a quote