Category: Migration & Transfer Services

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 HAQM Web Services (AWS). The division faced the need for a hardware refresh, continuing cost reduction pressures, and a […]

AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS quickly and securely. You can migrate your data to and from most widely used commercial and open-source databases, such as Oracle, Microsoft SQL Server, and PostgreSQL. The service supports homogeneous migrations such as Oracle to Oracle, and also heterogeneous migrations between different database […]

This blog post explains how to use PowerShell and native Microsoft SQL Server backups to migrate an on-premises SQL Server database to an HAQM EC2 instance. In general, we recommend that where possible you should make every attempt to migrate your on-premises SQL Server databases to HAQM RDS. You can find more details on how […]

We are excited to announce a new feature in AWS Database Migration Service (AWS DMS) and HAQM RDS for SQL Server that supports ongoing replication from HAQM RDS for SQL Server sources. AWS DMS helps you migrate databases to AWS quickly and more securely. It also helps you migrate data within AWS. You can migrate […]

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

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

Increasingly, customers are looking to move databases from proprietary engines such as Oracle and Microsoft SQL Server to open source engines running on AWS. One of the preferred destinations for this data is HAQM Aurora. In this post, we walk through a migration of a Microsoft Azure SQL database to an HAQM Aurora MySQL cluster […]

This post describes the performance aspects of migrating data to HAQM DynamoDB using AWS DMS, minimizing downtime, and converting the data that is more suitable for DynamoDB using either map to record or map to document types.

The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations more predictable by automatically converting the source database schema and most of the database code objects to a format compatible with the target database. To help with migration of on-premises data warehouses to HAQM Redshift, the new version of AWS SCT adds the following important […]

Let’s start with a quick recap from our previous posts, Debugging Your AWS DMS Migrations: What to Do When Things Go Wrong, Part 1 and Part 2. There, we cover the initial steps to take to debug your AWS Database Migration Service (DMS) migrations for environmental issues and to use HAQM CloudWatch metrics to identify […]