CODEWITHSUNDEEP
mysqldatabasemigrationmysql-workbench
user3285356
user3285356

Reputation: 67

mysql workbench migrate database with two different names

I'm using mysql workbench to try and migrate from 1 mysql database on my VPS to another on my DS; However the database names are different and I cannot change the database names due to restrictions.

When trying to migrate from the VPS to the DS I get an error because the two database names are different.

Is it possible in mysql workbench to set this up correctly as I can't seem to find it.

Upvotes: 6

Views: 4239

Answers (1)

Miłosz Bodzek
Miłosz Bodzek

Reputation: 1369

Yes, you can do it in manual editing step. From view combobox select All Objects, then double click on target schema name and rename it.

enter image description here

Upvotes: 15

Related Questions