Erwin generated DDL

Question

question

Katie 1 asked Mar 30, '10

Erwin generated DDL

Guys,

I am really curious to know if there are any known issues with the erwin generated DDL running on SQL SERVER? The version of SQL SERVER i am using is .. SQL SERVER 2008, not sure of what version of Erwin is used.

I have run them couple of times... and they were never smooth for me. Is there something that we need to tweek the code.. when we run it on the actual sql server database. And also.. i wonder if the erwin generates the script with the right order of the DDL. Here what i mean is applying the foriegn constraints ?

thanks!

sql-server-2008 sql script ddl erwin

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-03-30T18:18:12Z

CirqueDeSQLeil answered Mar 30, '10

Based on past experience with the tool, we generated the DDL into separate scripts and then manually ran the scripts. IMO - you should evaluate every script that is generated to ensure that it is proper. It should also be deployed to a dev server and then a QA server to ensure that it worked properly.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-03-30T19:06:49Z

Grant Fritchey answered Mar 30, '10

If ERWin is anything like ERStudio, you may need to check their web site directly. The older version of ERStudio didn't support all the new data types in SQL Server 2008. There's no way ERwin could be behaving any differently.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2010-03-30T23:21:11Z

Jay Bonk answered Mar 30, '10

I've used ErWin on and off since version 3.5.2 through 7, and have never been thrilled with the generated DDL and have always had to manually tweak the code to get it the way I had intended it to be. I also agree with CirqueDeSQLeil that you need to run it against a development server first to make sure it's what you expect it to be.

One other thing that I didn't like about ErWin, was that I would create a database using their generated DDL without changing anything - then immediately do a database compare, and it would find differences in column order on indexes or column nullability. I'm not sure if it was something I was doing, or the tool - but it happened enough times for me to always look at what got generated

For awhile I have been using ModelRight - I do have to say I like it much better. I'm pretty sure that are other modeling tools out there as well that are either commercial or open source that have eclipsed ErWin.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 4 · 2010-03-31T13:15:43Z

Katie 1 answered Mar 31, '10

Thanks a lot for the responses.

CirqueDeSQLeil--Seriously, i was concerned if it was me.. who was taking such long time to execute the script .. where as our datamodeller and the remaining team staring at me thinking "does it take soo long.. as we already handed the complete script to you.." And usually i execute them on the dev server one by one.. and confirm the output.

Jay-- you are so right about the differences that pop up. It happened to me too. I will try to have a look at model right.. and check for myself.

Grant-- thankyou for the suggestion. I will try to check with the Website.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question