问题原文
原帖链接 · James · CC BY-SA 4.0
I need to use AWS DMS to copy one MySQL RDS instance to the other. I've been tinkering about have set it all up and I've run a successful migration. The issue is it doesn't create indexes.
I understand the reason behind this, obviously it's much quicker to copy without but I have too many tables over a number of schemas to add them back manually. Is there any way to get DMS to copy the indexes over after replication? Or an alternative solution?
社区高分解答
原帖链接 · James · CC BY-SA 4.0
It turns out DMS will only ever create primary keys and perhaps a couple more indexes if you're lucky.
There are of course ways to get around this using mysql commands but the AWS way to acheive a DB migration I've found is to first copy the schemas from one DB to another using the AWS schema conversion tool, then use AWS DMS to copy your data over.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
