August 13, 2012 at 11:00 am
Has anyone heard of a command line or similarly scripted ERD tool that could be used to automatically refresh a snapshot of a DB schema?
Here is my use case. I have a segment of my user population for which I would like to cull out parts of the DB Schema and represent them in a DB diagram. This would help them to see parts of the data schema and how the tables relate when using a particular function of the application. Obviously I could create and maintain this by hand, but that would take time that I cannot spare at the moment.
In a perfect world, I could create a project like file that contained a reference to the DB to be diagrammed and a list of objects to be included in the diagram.
I would be able to call the application from command line and pass in the project file.
The output would be a PDF, PNG or other web presentable file that contained an ERD style document of the objects specified in the project file.
Does such a tool exist, or is there a set of tools that could help me accomplish the same task?
Steve
August 13, 2012 at 12:26 pm
To get an ERD diagram and do it automatically, I'd take a look at Embarcadero DBArtisan. It has a command line utility, reporting mechanisms, and a scripting language, that will allow you to do what you want.
If you didn't need the ERD diagram, I'd suggest looking at Red Gate SQL Compare. It does everything that you're asking for except generate an ERD diagram. DISCLOSURE: I work for Red Gate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply