AWS Database Migration Service now automates time-intensive schema conversion tasks using generative AI

 Starting today, AWS Database Migration Service Schema Conversion (AWS DMS SC) introduces a new capability to improve the database schema conversion experience by automatically converting up to 90 percent of schema objects from commercial databases to PostgreSQL migrations.

AWS DMS is a cloud service that makes it possible to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the Amazon Web Services (AWS) Cloud or between combinations of cloud and on-premises setups.

Today, more than 1 million databases have been migrated using AWS Database Migration Service. AWS DMS helps you migrate your data from one database system to another. And, when migrating between different database engines, AWS DMS SC helps to convert the source database schema and procedures to the target database system.




Generative AI–assisted code conversion helps to reduce migration costs and accelerate project timelines. Because AWS DMS SC automates more of the schema conversion process, you can focus on higher value tasks such as refining and optimizing your applications post-migration rather than manually resolving conversion gaps. Our beta customers have already experienced success with these AI-powered features in AWS DMS SC, achieving cost savings and faster migrations.


I start with a self-managed commercial database running on Amazon Elastic Compute Cloud (Amazon EC2). I use the AWS Management Console to define the instance profile and the data providers. This is where I configure the replication instance network details, the database engine and its endpoint, the secret where the database password is securely stored, and more. I also create a migration project. These steps aren’t new, and you can refer to Accelerate your database migration journey using AWS DMS Schema Conversion in the AWS Database Blog to learn about the details.

After my project is created, I select it, and on the Schema conversion tab, I choose Launch schema conversion. It takes a couple of minutes to launch the conversion tool the first time.

More info: 

Website Link: https://databasescientist.org/ 

Contact Us: contact@databasescientist.org


_______________________________________________________________________________________________________________   

Social Media:




Face Book: https://www.facebook.com/profile.php?id=61577089538169


Comments

Post a Comment

Popular posts from this blog

Large Language Models and Vector Databases for News Recommendations

Image
  Large Language Models   (LLMs) generated a global buzz in the machine learning community with recent releases of generative AI tools such as Chat-GPT, Bard, and others alike. One of the core ideas behind these solutions is to compute a numerical representation of unstructured data (such as texts and images) and find similarities between these representations. However, taking all of these concepts into a production environment has its own set of machine learning engineering challenges: How to generate these representations quickly? How to store them in a proper database? How to quickly compute similarities for production environments? In this article, I introduce two open-source solutions that aim to solve these questions: Sentence Transformers  [1] : an embedding generation technique based on textual information and; Qdrant : a vector database capable of storing embeddings and providing an easy interface to query them. These tools are applied to NPR [2], a News Portal R...
Read more

Is Palantir creating a national database of US citizens?

Image
According to its website, Palantir makes "products for human-driven analysis of real-world data." On May 30, 2025,  The New York Times published an article   titled "Trump Taps Palantir to Compile Data on Americans," detailing a supposed combined effort between the U.S. federal government and the data software company Palantir to centralize data on American citizens. Data privacy advocates did not take the news well, calling it "dystopian" and a massive invasion of privacy. Four days later, Palantir posted a statement to X responding to the article, calling the reporting " blatantly untrue" because "Palantir never collects data to unlawfully surveil Americans, and our Foundry platform employs granular security protections." On June 9, 2025, the company followed up with a long blog post on X titled " Correcting the Record: Responses to the May 30, 2025 New York Times Article on Palantir," which aimed to fact-check the article....
Read more

NIH autism database announcement raises concerns among researchers

Image
A new research initiative from the U.S. National Institutes of Health (NIH) seeks to gather and analyze multiple autism-related datasets to better understand the underlying causes of the condition. Letters of intent are due tomorrow, but the project’s atypical call for applications has autism scientists divided on whether or not to participate. The Autism Data Science Initiative provides $50 million for an anticipated 10 to 25 projects, according to the 27 May announcement. The funding opportunity uses an Other Transaction (OT) funding mechanism, which tends to be implemented when, among other reasons, a project is expected to evolve over time, more collaboration is required from the NIH or nontraditional research groups are involved, according to an NIH website. For a field that has recently seen budget cuts, some researchers are welcoming the opportunity for funding, says   Helen Tager-Flusberg , director of the Center for Autism Research Excellence at Bosto...
Read more