I have difficulties getting model comparer to work. It generates internal errors.
And when trying to expand nodes it freezes alltogether.
But something else was on my mind.
Why isn’t the comparer as in CS2 ? There were colors, icons. I’m lost in the visual interpretations of differences in TDM3.
I was looking only for missing entities, attributes and it’s wuite hard to filter all the lines.
I’m using Mysql model with custom user types, so almost each entity and attribute is different, because in real database there are simple data types and in my model there are custom dictionary types. Would it be possible to compare models by physical data type ? And would it be possible to add some kind of user dictionary type prediction ?
When I have decimal(3,0) as TYP_SS, and there are new attributes in real database with this data type, it could hint me that I have a dictionary type for it.
There is also a lack of context menu everywhere in the comparer. I think CS2 had it good, only the problematic NOT NULL fields in mysql where a drawback.
The last thing on my mind. I started model comparer. I spent almost half an hour to sort out differences and then I discovered that there is no ALTER button to press. What a pitty… Some button would be great that would change the comparer into alter/merge comparer .
Oh, and one thing more. I tried also the model update feature which combines multiple separate dialogs. handy. But what when in comparer step I discover that some tables were forgotten in reverse engineering step ? If the reverseengineering and comparer were closely bond together so that I could import the missing table right there without reverting to reverse engineering and loosing all the pitty work.
I’m not sure, if it is there or not, but there could also be somekind of review after merging so that I could see what will be done before I start the merge/alter process.