AWS Database Blog
Tag: migration
Oracle Database zero downtime migration with AWS Database Migration Service and Accelario
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.
Best practices for migrating an Oracle database to Amazon RDS PostgreSQL or Amazon Aurora PostgreSQL: Target database considerations for the PostgreSQL environment
An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog post is the third in a series that discusses high-level aspects about the components to consider for a database migration. The series doesn’t […]
Best practices for migrating an Oracle database to Amazon RDS PostgreSQL or Amazon Aurora PostgreSQL: Source database considerations for the Oracle and AWS DMS CDC environment
An Oracle to PostgreSQL migration in AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. To better understand details of the complexities involved, see the AWS Database Blog post Database Migration—What Do You Need to Know Before You Start? This blog […]
Best practices for migrating an Oracle database to Amazon RDS PostgreSQL or Amazon Aurora PostgreSQL: Migration process and infrastructure considerations
An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog series covers the environment and configuration setups for your source Oracle database, the AWS Database Migration (AWS DMS) service, and the target PostgreSQL […]
Migrate Apache Cassandra databases to Amazon DynamoDB more easily
Customers tell us that migrating data between different database engines—also known as a heterogeneous migration—can be challenging and time consuming. Some customers such as Samsung had to figure out on their own how to migrate their Apache Cassandra databases to Amazon DynamoDB (see Moving a Galaxy into the Cloud: Best Practices from Samsung on Migrating […]
How New Innovations migrated their residency management platform from Microsoft SQL Server to Amazon Aurora PostgreSQL
New Innovations has built a business around shared ideas and beliefs that all point to a larger purpose—empowering medical educators and administrators to provide quality medical education. Intelligence is advancing to the point where there is no separation between task and technology, and the result is that medical trainees and educators can be relieved of mundane administrative duties. Our partners in medical education work with us so that one day this ideal future becomes a reality.
The future is not far away, and thanks to AWS and Amazon Aurora PostgreSQL, our company has been able to build an infrastructure that scales to meet our customers’ demands. AWS Database Migration Service (AWS DMS) made our transition to Aurora PostgreSQL a seamless experience for both our customers and our software developers, while minimizing the risk. We used AWS DMS to fully migrate 700+ instances of Microsoft SQL Server to Aurora PostgreSQL. In addition, Amazon RDS Performance Insights now gives us excellent visibility into our database layer and allows us to respond quickly to any abnormalities.
How SGK simplified the data structure of a highly dynamic workload by migrating from an RDBMS to Amazon DynamoDB
Many database solutions are available today, and choosing the right one for your use case can be difficult. Recently, NoSQL databases have been widely adopted for real-time web applications. Amazon DynamoDB is an example of a NoSQL database that is optimized to yield significant flexibility and performance benefits over a traditional relational database management system […]
How to migrate an application from an on-premises Oracle database to Amazon RDS for PostgreSQL
For years, companies have had to set up their own local databases and maintain the hardware themselves. However, as the cloud infrastructure continues to improve, there’s far less need to own and manage your own hardware. Here at Amazon, we own hundreds (if not thousands) of on-premises databases that over time we have migrated to […]
Best practices for migrating RDS for MySQL databases to Amazon Aurora
MySQL is the most popular open-source database in the world. However, many customers find that the undifferentiated heavy lifting of backups, high availability, and scaling of MySQL databases to be complex, time-consuming, or both. This is one of the leading reasons why customers move their existing MySQL footprint to Amazon RDS for MySQL. Amazon RDS […]
How to work with native CDC support in AWS DMS
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 […]