Amazon has expanded the AWS Database Migration Service (DMS) with new features, including SSL-enabled endpoints, further database compatibility and the ability to support continuous data replication.
The AWS DMS was made generally available to users of Amazon's cloud platform in March. It is designed to enable IT professionals to migrate a database from an on-premise server to the AWS cloud with no downtime, and also allows them to migrate the dataset itself from one database engine to a different one, if required.
Amazon has now expanded the service with new capabilities to make it even more useful. For example, as well as supporting one-time migration of data, it can now be used for continuous data replication, enabling customers to maintain a mirror of the data in case of a failure.
The feature supports replication from the customer's data centre to AWS, or in the reverse direction, replicating from a database operating on AWS to one in the customer's data centre.
The DMS already allows migration of data from one database engine, such as Oracle, to another, such as PostgreSQL, but the new continuous replication feature offers even more flexibility to choose the configuration that best suits a company's requirements.
Amazon recommends that for ongoing replication, customers should use Multi-AZ for high-availability, whereby the Amazon Relational Database Service automatically maintains a standby instance of a database in a separate AWS Availability Zone.
Other improvements focus on security. DMS now supports SSL-enabled endpoints for SQL Server, PostgreSQL, Amazon Aurora, MySQL and MariaDB, Amazon said.
Finally, the DMS also now supports the SAP ASE (formerly Sybase Adaptive Server Enterprise) database as a source and target for database migration operations.
Customers now have the option to move data to and from an ASE database running on-premise or on Amazon EC2 virtual machines. Data can also be moved between ASE and any of the other database engines supported by DMS, including Amazon Redshift, the firm said.
Cotton seedling freezes to death as Chang'e-4 shuts down for the Moon's 14-day lunar night
Fortnite easily out-earns PUBG, Assassin's Creed Odyssey and Red Dead Redemption 2 in 2018
Meteor showers as a service will be visible for about 100 kilometres in all directions
Saturn's rings only formed in the past 100 million years, suggests analysis of Cassini space probe data
New findings contradict conventional belief that Saturn's rings were formed along with the planet about 4.5 billion years ago