Category: Enterprise Strategy

In this post, we focus on database object validation for the heterogenous migration from SAP ASE to Amazon Relational Database Service (Amazon RDS) for MySQL, Amazon RDS for MariaDB, or Amazon Aurora MySQL-Compatible Edition. For schema conversion and migration, you can use AWS Schema Conversion Tool (AWS SCT). AWS SCT helps convert your database schema […]

Amazon Database Migration Accelerator (Amazon DMA) helps you accelerate migrations to AWS Databases and Analytics services. Amazon DMA is comprised of migration domain experts including engineers, who can assist you with your migration strategy and planning to deploying your applications and databases to a production environment. Amazon DMA helps build a strong foundation for AWS Databases […]

For decades, IT administrators could only run their SQL Server workloads on Windows. However, as of SQL Server 2017, SQL Server is now available to run in the Linux operating system. For IT administrators, this represents an opportunity to run SQL Server workloads on their preferred operating system, save on Windows Server licensing costs, and […]

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 […]

To increase the speed and quality of development, you may use continuous delivery strategies to manage and deploy your application code changes. However, continuous delivery for database migrations is often a manual process. Adopting continuous integration and continuous delivery (CI/CD) for database migrations has the following benefits: An automated multi-account setup simplifies database migrations. The […]

Let’s say you have an application that uses database tables to store log and clickstream data. You might store your data in a relational database to ease development and management tasks. When you launch your application, the database is manageable at first, but it grows to hundreds of gigabytes per week. Data storage and retrieval […]

UPDATE, March 2019: Since this blog post was published, DMS has launched a new capability to set Kinesis as a target. For the most updated guidance, please visit Use the AWS Database Migration Service to Stream Change Data to Amazon Kinesis Data Streams. ———————————— Many large enterprises are moving their data processing from batch to […]

We are excited to introduce a new version of AWS Schema Conversion Tool (AWS SCT) that includes support for PostgreSQL 10 partitioning, a new server-level Assessment Report, support for table-valued functions, and more. For those of you who are new to AWS SCT, this tool helps convert your existing database schema from one database engine […]

AWS Database Migration Service (AWS DMS) today launches native CDC support and the ability to start and stop the AWS DMS replication from a specific checkpoint. When you work with this feature, you can use checkpoints such as a log sequence number (LSN) in Microsoft SQL Server, a system change number (SCN) in Oracle, and […]