It's so much easier using Embarcadero to forward engineer changes to a database than it is using Erwin. I've spoken to Erwin about this in the past, and I can understand why they're doing some of the things they're doing, but I'm more of a casual user than a power user, and for me, it's so clunky. A lot of times I need to change a column definition and all I want to do forward engineer it over to the database, it used to be so easy to do that, way back in the early days with Erwin before CA bought it, and now it's almost impossible. My biggest frustrations with the product is forward engineering and keeping things in sync. But so many things that are clunky with it. I always come back to it because every other tool has its own set of problems, and it seems like if I have to pick my poison, I stay with Erwin. I've tried to get off of Erwin a few times. Resizing dialog boxes, changing fonts, printing, scrolling around in the UI, etc is very clunky. The whole workflow of adding columns to a table could be so much easier. I find the UI very clunky and very difficult to use. It doesn't support Postgres or Redshift which are the two other systems that we're using.
#Erwin data modeler standard edition code#
Its ability to generate database code from a model for a wide array of data sources is useful but we're 99% SQL Server, so the fact that it generates 60 other databases doesn't really help me too much. The number one benefit of using a tool like Erwin, is that visual representation forces you to come up with a better model. That's number one, in my opinion, from my own experience. It forces you to ask questions that you wouldn't ask if you were just creating tables and doing it off the top of your head. If you use a data modeling tool, the graphical nature of the data modeling tool forces you to think about relationships. The people who don't use a data modeling tool but rather use spreadsheets or wing it typically have pretty poor data models. It's just very frustrating in some areas that really should not be frustrating.
The general principles of what a data modeling tool does.Įrwin does a lot of things well.
0 kommentar(er)
