Automate SQL Server DB Schema Diagram Generation?

Ok - third time lucky I don't know of any tool that can do this in one step - but I don't think that any of them are going to do what you want (except for probably some really high end tools) Thus, I think that your best bet is to use one of the aforementioned script like dbschema. Pl and send the output to something like sql2diagram This should be simple to script up - and the email the output to whomever needs to see it. Since you have the text output at the intermediate stage, you can highlight diffs as well bby preserving multiple copies of the output Can you clarify what you mean by "Organize the tables.

Ok - third time lucky. I don't know of any tool that can do this in one step - but I don't think that any of them are going to do what you want (except for probably some really high end tools). Thus, I think that your best bet is to use one of the aforementioned script like dbschema.Pl and send the output to something like sql2diagram This should be simple to script up - and the email the output to whomever needs to see it.

Since you have the text output at the intermediate stage, you can highlight diffs as well bby preserving multiple copies of the output. Can you clarify what you mean by "Organize the tables.

Thanks for this it looks promising I will give it a go and see if it works. – Burt Jan 13 '10 at 11:00.

Have a look at DBSchema - this is quite a good tool. It dumps your DDL to files each day, you can then see what's changed day on day by a simple text comparison. Clearly, implicitly, you also get something that you could use to regenerate the structure of your DB as well.

If you insist that people check DDL into CVS, then you can also use it to spot changes that people have made ad-hoc to the db structure without checking into source control. Hope this helps, Ace.

Unfortunately I need to be able to generate an image from the schema for the business analysts to use during their specifications. – Burt Jan 9 '10 at 23:31.

It needs everything. Reverse engineer is a pain and we were looking to automate this step. – Burt Jan 12 '10 at 10:10 The database diagram looks promising but it would still need manual intervention to organise the tables which we are looking to avoid.

– Burt Jan 12 '10 at 10:14.

My application dbscript generates Dia diagrams from a database schema. Since Dia exports various formats, it should be no problem to import into Visio.

Last week I was looking for the same for my DB, as i'm using MySql in my project I tried MySql workbench and it really works for me. After you install it you can enter you DB conection setting and choose a dataBase and do a reverse-engineer , and get a BD diagram very detailed in a few steps. It has a lot of documentation if you get lost in any step.(sorry for my english).

This looks interesting but I need something for SQL-Server – Burt Jan 15 '10 at 9:21.

RedGate SQL Toolkit will be your life server. Take a look at this question and my answer stackoverflow.com/questions/2031712/nhib....

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.