Tag: AWS Database Migration Service

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

Application developers and system administrators replicate data across datastores to migrate, refresh, and mask data. For most organizations, data replication is a complex, multiphase process, including assessment, schema conversion, script conversion, data migration, functional testing, performance tuning, and other tasks. Multiple tools are available to support data replication. AWS Database Migration Service (DMS) helps you quickly […]

Expanding on the earlier post, Create AWS CloudFormation templates for AWS DMS tasks using Microsoft Excel, this post highlights an enhanced feature of the same tool that can speed database migration. To demonstrate this feature, we present a small command line tool written in Python. The tool takes a CSV file containing the names of […]

Today AWS DMS announces support for migrating data to Amazon S3 from any AWS-supported source in Apache Parquet data format. This is one of the many new features in DMS 3.1.3. Many of you use the “S3 as a target” support in DMS to build data lakes. Then, you use this data with other AWS […]

AWS now supports new data transformation capabilities in the latest AWS Database Migration Service (AWS DMS) version 3.1.3. You can change schema, table, and column names; specify individual tablespace names for Oracle targets; and update a table’s primary and unique key on any target. DMS version 3.1.3 supports the following new data transformation capabilities: Explicit table […]

With AWS Database Migration Service (AWS DMS), you can migrate databases to AWS quickly and securely. In this post, we walk through the sample Python code required to download AWS DMS task logs on to your local computer using the AWS DMS task ID. Overview The DMS task logs contain task information logged during the […]

AWS Database Migration Service (DMS) helps you migrate databases to AWS quickly and securely. The AWS DMS migration process encompasses setting up a replication instance, source and target endpoints, and replication tasks. Your replication instance uses resources like CPU, memory, storage, and I/O, which may get constrained depending on the size of your instance and the […]

September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. A common pattern for web application architecture includes a database for application data coupled with a search engine for searching that data. Many relational and even nonrelational databases offer rudimentary search capabilities. However, search engines add true, complex, natural-language search […]

This blog post talks about a tool that automates creation of AWS CloudFormation templates for AWS Database Migration Service (AWS DMS) tasks. If you are looking for how to create CloudFormation templates for your DMS tasks and don’t have knowledge of CloudFormation, read on. Many times during database migration activities where AWS DMS is involved, […]

Accelario is database migration software that provides a fast and easy way to load an Oracle database to Amazon Web Services (AWS). At the end of the initial load, database synchronization starts immediately using AWS Database Migration Service (AWS DMS), and the result is a zero downtime migration of your database.

Businesses that require 24/7 operation face a significant issue when moving databases into the cloud: Up until now, few if any cost-effective options existed to minimize the resulting downtime. With its recent integration with AWS DMS, Accelario provides a ready-to-use, zero downtime, full database migration solution—meaning that the whole database is migrated, including users, procedures, views, etc. When the process is done, you can access your database and start using it with your application immediately.