AWS Database Migration Support

Take advantage of our experienced professionals with deep knowledge of AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) to migrate your databases to Amazon RDS, Amazon Aurora, and Amazon Redshift.

Introducing the AWS database migration service support offer

ABCloudZ will streamline your migration to AWS and provide explicit support with any questions or issues related to the AWS DMS and SCT services.

To help guide you through the database migration process, we are offering a package of 40 hours to help jumpstart your migration project effort to AWS. With unparalleled experience in all major databases — Oracle, Microsoft SQL Server, IBM DB2, Sybase, Access, MySQL, PostgreSQL, Teradata, Greenplum, Netezza, and Amazon Redshift – we are ready to help you develop cost-effective strategies for migrating and modernizing your application assets to AWS technologies.

002_aws_1

Whether you are migrating your OLTP workloads to PostgreSQL, MySQL, Aurora for PostgreSQL, Aurora for MySQL, or migrating your data warehouse applications to Redshift, our experienced team can help you navigate through any potential obstacles or barriers in the process.

AWS SCT Jumpstart 2

ABCloudZ can also help you migrate your Cassandra workloads to Amazon DynamoDB. Our team has hands-on experience migrating Cassandra workloads using Amazon’s data extraction agents. ABCloudZ knows all the gotchas and workarounds of this migration path, as we have already completed migration projects of this type for our customers.

AWS SCT Jumpstart 3

See examples of how we can help you get started below.

AWS Schema Conversion Tool support

ABCloudZ can help your team get up and running with AWS SCT so that you can take advantage of all the features it offers. Whether you need help understanding the assessment report, configuring migration options, using the scripting console options, or optimizing data warehouse options, we can provide your team with the customized help that you need.

Migrating schema objects

AWS SCT automatically converts database objects that it understands. However, there are some database object constructs that are too complex for AWS SCT to handle due to possible ambiguities. We know exactly what the issues are and can help manually convert the code to your desired AWS RDS target database. In addition, we can help you understand the estimates from the assessment report to help scope your migration project with greater accuracy. In some cases, a migration project requires additional automation to improve the conversion rate on top of AWS SCT. The ABCloudZ development team is happy to help build additional automation layers to expedite your migration projects.

Migrating data

The AWS Database Migration Service is a web service that you can use to migrate data from a source database to a target database. We can help you set up custom mapping rules between AWS DMS and AWS SCT. For very large data volumes, you may need to use the AWS Snowball service to ship your data to an AWS data center and then load it into your target AWS RDS or Amazon Redshift database. Our experts can help develop strategies and customized data movement scripts using popular data integration tools to ensure data integrity throughout the project.

Application code conversion

AWS SCT can identify and convert application code for Java, C++, C#, or “any” source projects using the AWS SCT Application Conversion Project. It’s certainly a great start, however, it’s not perfect. ABCloudZ has a variety of in-house tools to help identify application code and fix the code to work against the new AWS RDS database. In addition, if you are looking to change the application front end from Oracle Forms to Web Applications, we have tools and processes to guide you through the rewrite effort.

Migration conversion testing

After AWS SCT finishes converting the code, you need to test its correctness. Functional testing represents approximately 30% of the migration effort. We have our homegrown tools and frameworks which can help to expedite the functional testing process.

Performance testing

AWS SCT uses a migration extension library for the source database to emulate the same feature using the target AWS RDS database. In many cases, our experts can improve performance by looking at the intent of the source object and then using the native functionality of target AWS RDS to achieve that same functionality. For data warehouse migration, our experts can show you how to use SCT’s optimization tools to get the best performance out of Amazon Redshift.

Architectural design and product guidance

Database schema conversion typically represents approximately 15% of the effort in a migration project. AWS DMS and SCT will not do it all. Our experts can work with your team to evaluate your current database, applications, and infrastructure to help you develop the future state architecture. From there, we can work with your team to develop a project plan to place you on a path to success.

AWS services discovery

In some cases, database features can’t be converted to equivalent Amazon Relational Database Service features. Some examples are Oracle send email calls that use UTL_SMTP, and Microsoft SQL Server jobs that use a job scheduler. If you host and self-manage a database on the Amazon Elastic Compute Cloud (Amazon EC2) platform, you can emulate these features by substituting AWS services for them. Our experts can help you configure AWS Services for sending emails and performing automated jobs using AWS Lambda functions. We can also help you to extend existing libraries to provide greater support for missing source database features using the existing foundation provided by AWS SCT Extension libraries.

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 may start with capturing performance metrics of your on-premises databases and then 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 will be happy to assist you.

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

Innovative solutions using AWS DMS and SCT

One of the leading independent education software vendors wanted to add a new PostgreSQL database running on AWS to their original Oracle database system. They also needed to upgrade connected Java applications 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 our technical approach to this project. We leveraged this automated conversion tool for code migration and unification.