Questions tagged with General Database Migrations

How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle. We see SCT is useful to move Source Schema (Eg: Oracle ) to Target Schema DB (Eg: Aurora Postgres) and other limited DB combinations. Now requirement is to migrate from On-premise Oracle to MS SQL Server in AWS Cloud. Please let me know if anyone has worked on this task.

Hi We are creating a DMS task that we were expecting to use a view in a Aurora Postgres service as data source, for a single use table migration. But it seems that views arent actually supported in this specific source case .... any reason for this? Theres a column which serves as primary key for that view Below is the message when creating the DMS task Error in mapping rules. Rule with ruleId = 042389161 failed validation. view selection is not available for aurora-postgresql source type In the meantime, im looking towards AWS Glue to do the procedure, and in the "worst" case, create a procedure to do the task / load process Any tips would be great for the ones that may fall for the same case best regards

Want to know which AWS service will help me to transfer data from RDS to Keyspaces Cassandra on real time basis. #Case I am using RDS MYSQL as a production database and i have also created a read replica for the same. Now i want that as and when new data updated on my database then it automatically transferred to keyspace cassandra for further use.

If I have an application that is currently using MongoDB Atlas (not hosted on AWS), should I migrate to AWS DocumentDB if the rest of my infrastructure is running on AWS? What should I look out for when migrating? Are there any bugs or known issues between the two services, and what type of support does DocumentDB get for new MongoDB features? I'd love a pros/cons list of running each service so I can make a good decision.

Hi there, I am planning to migrate our on-prem SQL Server to RDS SQL Server. Unfortunately, this db was managed by several people and we are not sure that all of the tables have a primary key. I wish to keep the on-prem db and RDS in sync for a couple of days, so I have to be 100% sure that all tables have a primary key. Do you know an automatic way, where I can check if all the tables (1000+) have a primary key? Cheers, Mark