Bug #42761 change database name

• Submitted: 11 Feb 2009 13:34
• Modified: 19 Oct 2009 11:29
• Reporter: Susanne Ebrecht
• Status: Won't fix
• Category: MySQL Migration Toolkit
• Severity: S4 (Feature request)
• Version: 1.1.16
• OS: Any
• CPU Architecture: Any
• Tags: CHECKED

[11 Feb 2009 13:34] Susanne Ebrecht

Description:
It would be nice when the user would have the chance to change the database name during migration.

An example from migration from PostgreSQL to MySQL:

PostgreSQL hirarchie:
Database -> Schema -> Table -> Column

MySQL hirarchie:
Database/Schema -> Table -> Column

Default schema in PostgreSQL is public. When you know migrate more then one database the MT will give them all the name "public".

It would be nice to have a field at the source database selection where you can say from Schema to Schema ...

Means you select from "public" and have a fill out field where you will be able to change the name for MySQL ... something like: Database name in MySQL: PLEASE FILL OUT HERE

So that by automatism MySQL will migrate from old name foo to new name bar

How to repeat:
...

Suggested fix:
...

[19 Oct 2009 11:29] Susanne Ebrecht

Workaround is to use RENAME here.

We won't fix this anymore.