Eric M Russell (6/24/2016)

---

roger.plowman (6/24/2016)

---

Eric M Russell (6/24/2016)

---

roger.plowman (6/24/2016)

---

The ERD is supposed to create the DDL for you. That's what it's *for*... 😀

Umm... no. :unsure:

Ah, clearly you are unfamiliar with the miracle that is ModelRight when combined with Redgate's SQL Compare and Data Compare. You create the model (which is all the documentation, pretty pictures, comments, notes, etc. for the interminable meetings) then let ModelRight create the DDL code--no extra work for the DBA! It's literally 3 mouse clicks to create the entire script! 😎

Not only that, but it has internal consistency checks to make sure the model you create is actually viable when it hits the server. Does reverse engineering too.

A bit pricey, but quickly pays for itself.

You're just being facetious. :Whistling: