Schema Sync – Renamed Table Issue

[maxhugen]

Step 1

=====

In Database A, I have renamed most – but not all – columns in a table `table_A`.

I then did a Schema Sync to Database B – all OK.

Step 2

=====

Then, in Database A, I have renamed the table from `table_A` to `table_B`.

When I did a Schema Sync to Database B:

– table_B was created, but with no records

– table_A was still there

— with the original number of records, but

— the columns were all null:

— except for the Auto Increment Primary Key (with new values starting from 1)

— columns with a Default value

— columns whose name had not been changed in Step 1.

This is a major problem for me, as I have to rename tables and columns for an entire database,

Is this a known issue with SQLyog? (I am using v10.2)

[Author]

Posts