Qualify workloads - AWS Prescriptive Guidance

Qualify workloads

To determine the best migration strategy for your database, it’s important to understand the current database workload. You need to analyze your database to determine which features you are currently using and what’s involved in migrating to another cloud-native database engine such as Amazon Aurora PostgreSQL.

AWS provides a workload qualification tool called AWS Workload Qualification Framework (AWS WQF). This tool can help identify the complexity of your Oracle and Microsoft SQL Server database migration by analyzing database schemas and code objects, application code, dependencies, performance characteristics, and similar inputs. WQF provides recommendations on the target database engine. It also estimates the type of work involved and the level of effort required. Here’s a sample assessment report generated by WQF:

     AWS Workload Qualification Framework (AWS WQF) sample report

WQF evaluates your migration workload and places it in one of these five workload categories:

  • Category 1: Workloads that use Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC) instead of proprietary drivers to connect to the database. This category typically has fewer than 50 custom stored procedures, or has simple stored procedures that are used for access controls.

  • Category 2: Workloads with light use of proprietary features. Generally, this type of workload has fewer than 200 stored procedures and doesn't use advanced SQL language features.

  • Category 3: Workloads with heavy use of proprietary features. Workloads in this category are completely driven by advanced stored procedure logic or proprietary features. In the field, many of the workloads in this category have as many as 100,000 lines of database-resident code and features.

  • Category 4: Engine-specific workloads. Workloads in this category use frameworks that can work only with a specific commercial database engine. For example, these frameworks might include Oracle Forms, Oracle Reports, Oracle Application Development Framework (ADF), Oracle Application Express (APEX), or applications that use .NET ActiveRecord extensively.

  • Category 5: Nonportable, unacceptable risk, or "lift and shift" workloads. Workloads in this category might be implemented on database engines that have no cloud-based equivalent. In some cases, you might not have the source code for these programs.

This categorization can help you determine the migration path for your application, as we’ll discuss in the section Phase 2: Plan. For more information about installing and using AWS WQF, see the AWS WQF documentation.