I have two RDS instances, one for PROD and other one for DEV. I want make daily backups of prod instance and replicate into a dev instance. The problem is that when I take a snapshot of prod instance, for restore that snapshot, AWS creates a new RDS instance.
What I want is bulk the new changes/data of the prod instance into a dev instance and daily have the same info in both instances.
Any ideas?