Data source / Database diff & Migration

Hi,

I'm evaluating the Data source / Database compare and the "Migrate Left/Right" Feature.

I have created two identical databases with the same tables and then created one additional table at one of them.
When I'm comparing the two databases the compare view proposes to copy the new table to the other database (in my case copy from left to right).
If I choose "Migrate Right" I am getting the CREATE SQL - so far so good. If I choose "Migrate Left" I am getting a "DROP TABLE".

From my point of this should not be a "DROP TABLE" SQL - instead it should be simply ignored because of the given direction "Set Copy to Right".

(see attached screenshots).



Attachment(s):
Selection_526.png
Selection_525.png
Selection_524.png
2 comments
Comment actions Permalink

What's your exact version of the IDE (Help | About)?

Please check: https://youtrack.jetbrains.com/issue/DBE-766 .

0
Comment actions Permalink

Hi,

Meanwhile I'm using the latest EAP (8.0.2 / 139.659). I already filed a bug to this because I found a second issue in the compare view:

https://youtrack.jetbrains.com/issue/WI-25773

0

Please sign in to leave a comment.