Questions tagged with Migration & Transfer
Content language: English
Sort by most recent
Split one table into multiple tables using AWS DMS?
Giving an example to explain my scenario - FileA has 100 attributes. FileB has 300 attributes. The attributes in Files A and B can be from multiple tables. These files are present in S3. We are going to import Files A and B into RDS Postgres. Now this Postgres will have Table A --> generated from File A (100 attributes) and Table B --> generated from File B (300 attributes) We now want to split Tables A & B into multiple smaller tables using AWS DMS. Source Postgres (Tables A & B) --> AWS DMS --> Target Postgres (Tables C, D, E, F) Is this possible? Any advice to implement this scenario? Please help
How many Nodes/Requested does Created/Manage by 1 ELB
I am new to ELB, Wanted to use Application load balancer. Total count of web users are near to 1k so How many ALB needed to manage these requests. How many nodes will be created by 1 ELB. How many EC2 can be configured to 1 ELB. Is it good to even go with 1 ELB to handle 4 EC2 or Go with 1 EC2 in which Apache load balancer install to handle these 4 EC2 since it is open source?
Move objects in Deep Glacier Archive from one account to another while preserving storage class
Looking for the best approach to moving data in S3 Glacier Deep Archive from one account to another, while preseving current storage class. Any solutions I've come across thus far seem to indicate that all data must be retreived from Deep Archive before copying, which feels redundant and costly given that the data should ultimately remain in Glacier Deep Archive in the destination account. What is the least costly approach to doing this? Can it be done without first performing (e.g.) a Bulk Retrieval on the original data and then subsequently moving back to Glacier Deep Archive in the destination account?
Back up from on-premis/my own machine to AWS backup.
Use case: I want to connect my machine with aws so that I can take a backup from my local machine. 2. I want whatever I change in a particular folder on my local machine that will sync to aws backup and backup should take place. 3. What are the ways i can take Backup from my local machine to AWS.
AWS DMS - CDC - Unique Constraint Error
# How to resolve "ORA-00001: unique constraint" during AWS DMS CDC mode ? Source - On Prem - Oracle || Target - AWS RDS - Oracle I exported source DB with Datapump with SCN, imported same on target and started migration task with same SCN but I am getting error "ORA-00001: unique constraint" , because of this migration task is slow and change mode to "one-by-one" from "Bulk Apply". I am getting above error for table which has more than 100 millions of records. How can I get rid of this error ? Do I need to change anything before I take export?
Can you combine S3 Transfer Acceleration with Horizontal Scaling & Request Parallelization?
Can you combine [S3 Transfer Acceleration](https://docs.aws.amazon.com/whitepapers/latest/s3-optimizing-performance-best-practices/using-amazon-s3-transfer-acceleration-to-accelerate-geographically-disparate-data-transfers.html) with [Horizontal Scaling & Request Parallelization](https://docs.aws.amazon.com/whitepapers/latest/s3-optimizing-performance-best-practices/horizontal-scaling-and-request-parallelization-for-high-throughput.html)? I assume you'd just need to enable Transfer Acceleration on the destination bucket and then use the Acceleration endpoint when setting up a parallelization mechanism like [TransferManager](https://docs.aws.amazon.com/sdk-for-java/v1/developer-guide/examples-s3-transfermanager.html)?
Can a DMS task have single source with multiple targets.
We have an RDS instance and want to replicate the data of the tables in that RDS to multiple targets. Below are the requirements. 1. Migrate data from source (RDS) to target (RDS). 2. Migrate data from source (RDS) to target (Kinesis). 3. Migrate data from source (RDS) to target (S3). 4. Migrate data from source (RDS) to target (Open Search). 5. Migrate data from source (RDS) to target (Redshift). For all the migration tasks, the source is same but the targets are different. Can we do the above mentioned migration with single DMS task or do we have to create multiple DMS tasks by taking a hit on the RDS instance performance?
Migrate SQL Server 2008/2012 to AWS
Hello, I have some 2008 and 2012 MS SQL Servers running on windows server in my on-premises. I want to migrate those to AWS. Looking for suggestions on what's the right migration path. 1. Should I first make an in-place upgrade of those SQL servers on-premise, then move to RDS? 2. Should I migrate those as-is using back and restore to EC2, then use AWS SSM playbook to upgrade to 2019? 3. Is there an option using AWS DMS or backup and restore to directly upgrade to 2019 on RDS? I'm ok to move those servers to either license included EC2 or to RDS with MS SQL. Thank you.
Migrate AWS Account
Hello Everybody, I plan to migrate AWS Account to different account by all services would be transferred as below - EC2 20-30 Instants - Cloudwatch - OpenSearh - Cloudfront - S3 - Load Balance EIP for ec2 are more than 20 IP. Therefore, AMI it's seem to be cannot migrate IP together with EC2 https://aws.amazon.com/premiumsupport/knowledge-center/account-transfer-ec2-instance/ Then, I have checked transferring EIP and found it need to open a support cases for this. https://repost.aws/questions/QUImID0dYDRR24o4PAEUPvyg/is-it-possible-move-migrate-eip-to-another-account This is my questions 1. To transfer EIP that Account Basic can do open a ticket for support this? 2. If must be developer, business and enterprise what is minimum type? 3. Just source account or destination must pay as well for support? https://us-east-1.console.aws.amazon.com/support/plans/home?region=us-east-1#/ All suggestions and recommendation, Thank you in advance.
How long will the AWS RDS outage take when enabling backups?
The documentation (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html) states that in case of changing the retention period from 0 to some positive number, there will be an outage. Unfortunately i cannot find any info on how long will it be. This is a production db for high availability service - and I do not want it to take like an hour or so. The db size is significant - about 100 GB. Does anyone know how long can it take?