Welcome to ModelRight Sign in | Join | Help
in

3041 / MySQL comparions problem with Enum Values

Last post 07-01-2008, 8:14 AM by modelright. 3 replies.
Sort Posts: Previous Next
  •  06-30-2008, 2:38 PM 679

    3041 / MySQL comparions problem with Enum Values

    Hi,

    When comparing I have a problem with Enum Values for 1 field : in model side : it's written "Enum Values : Valid Values List 2" and in Database side : "Enum Values : Valid Values List 1".

    If I change the model to "Enum Values : Valid Values List 1" and compare after : the problem is in the opposite, etc, etc.... !?!?!

     Any suggestion ?

     TIA,

    Phil

  •  06-30-2008, 2:52 PM 680 in reply to 679

    Re: 3041 / MySQL comparions problem with Enum Values

    Hi Phil,

     I am not sure that I fully understand the issue.... is the problem that the names are flagged as different?

    And what exactly happens if you rename the Valid Values List 2 to Valid Values List 1 in the model? The enum values in the database are still "Valid Values List 1", right? And the match with no difference, right?

     


    ModelRight Evangelist
  •  06-30-2008, 3:16 PM 681 in reply to 680

    Re: 3041 / MySQL comparions problem with Enum Values

    Yes, the names are different.

    If I rename in "Valid Values List 2" to "Valid Values List 1" in the model then I compare again : there is still the problem but in the opposite : "Valid Values List 1" in the model and "Valid Values List 2" in DB...so the problem remains (but in the opposite).

     Hope it's clearer :-)

  •  07-01-2008, 8:14 AM 682 in reply to 681

    Re: 3041 / MySQL comparions problem with Enum Values

    Hmmm... I guess I do not understand how renaming the object in the model would have any impact on the name of database object... they are independent objects, from different models!? Anyway, we will take a look at it & hope we can reproduce it.

    In meantime... are you familiar with the manual matching feature in Model/Database Compare? There are situations when, despite the tool's best guess, objects that should be matched are not matched because the tool is lacking the contextual/specific information to make such decision.

    For instance, let’s assume you have a table X in your model and while initially was forwarded as X in the database, someone decided to rename the table as Y. Now, when doing the database compare, X and Y are not matched since they have different names, but they should, so you can import the rename from the database into the model. This is where manual matching/un-matching comes handy.  You use the feature the match X and Y and then import Y into the model (and therefore renaming X to Y).

    So, for your particular problem, as a workaround, you can manually match Valid Values 1 and Valid Values 2.

    Hope this helps.

     


    ModelRight Evangelist