AWS Database Blog

Tag: Schema Conversion Tool (SCT)

Validating database objects after migration using AWS SCT and AWS DMS

Database migration can be a complicated task. It presents all the challenges of changing your software platform, understanding source data complexity, data loss checks, thoroughly testing existing functionality, comparing application performance, and validating your data. AWS provides several tools and services that provide a pre-migration checklist and migration assessments. You can use the AWS Schema […]

Read More

Classify OLTP and OLAP workloads using AWS SCT with Workload Qualification Framework (WQF)

Migration is a multiphase process, and different steps are involved based on the type of migration you’re doing. With the help of AWS Schema Conversion Tool (AWS SCT) reports and involvement of partners, you can automate more than 50 percent of the work. However, another large percentage of work still is required. This is where […]

Read More

AWS Database Migration Service and AWS Schema Conversion Tool now support IBM Db2 LUW as a source

Managing and operating relational databases is a basic piece of maintaining an effective business. Relational databases come in many flavors—commercial (Oracle, Microsoft SQL Server, IBM Db2, and so on) and open source (MySQL, PostgreSQL, and so on). With innovation and improvements in the open-source database world and cloud computing platforms like AWS, many enterprises are […]

Read More

Schema Conversion Tool blog series: Introducing new features in build 613

The AWS Schema Conversion Tool (AWS SCT) helps convert your existing database schema from one database engine to another. You can convert from a relational OLTP schema or any supported data warehouse OLAP schema to Amazon RDS (for example, Amazon Aurora MySQL or Amazon Aurora PostgreSQL, among others). You can also convert from a relational […]

Read More

How the AWS Schema Conversion Tool Drove Trimble’s Database Migration Successes

By Todd Hofert, Director of Infrastructure Operations—FSM at Trimble Inc. The situation Recently, the Infrastructure Operations Group for Trimble’s Field Service Management division embarked on an aggressive initiative to migrate their privately hosted SaaS offerings to Amazon Web Services (AWS). The division faced the need for a hardware refresh, continuing cost reduction pressures, and a […]

Read More

Challenges When Migrating from Oracle to PostgreSQL—and How to Overcome Them

David Rader is the vice president of engineering at OpenSCG. OpenSCG is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers migrate to, operate, and optimize PostgreSQL and other data platforms on premises and in the cloud. In previous posts, we looked at the overall approach for a successful database migration and […]

Read More

How to Migrate from MySQL to Amazon Aurora using AWS SCT and AWS DMS

MySQL is a great open-source database engine, which a lot of companies use because it’s cost-effective. However, like any other open-source database, it takes a lot of work to get commercial-grade performance out of it. As the size of your database increases, the complexity of scaling and crash recovery in MySQL also increases. Scaling out […]

Read More

New AWS DMS and AWS Snowball Integration Enables Mass Database Migrations and Migrations of Large Databases

Before reading this blog post, we recommend that you look at the AWS DMS, AWS SCT and AWS Snowball blogs and get to know these services. More than 40,000 databases have been migrated to AWS using AWS Database Migration Service (AWS DMS), either as a one-time migration or with ongoing replication. AWS Database Migration Service (AWS DMS) and AWS […]

Read More

Migrating a SQL Server Database to a MySQL-Compatible Database Engine

This post provides an overview of how you can migrate your Microsoft SQL Server database to a MySQL-compatible database engine such as Amazon RDS for MySQL, Amazon RDS for MariaDB, or Amazon Aurora MySQL. The following are the two main parts of a database migration: Schema conversion: Converting the schema objects is usually the most […]

Read More