database diagrams, how to save to sourcesafe ? tired of recreating...

  • Thread starter Thread starter Andrew Taylor
  • Start date Start date
A

Andrew Taylor

In VS.NET, I often create DB diagrams in the server explorer.

How do I save these diagrams ?

I need to persist all this stuff to sourcesafe, I can do that with my
code, my sql scripts, etc...but not the db diagrams ?


-- THanks, Andrew
 
Andrew,

If no one has a better idea, you might want to use Visio that would give you
a separate file you could but under source control.
 
Andrew:

I've never tried this, but...

Diagrams are stored across several records in the dtproperties table
of your database. Select * from dtproperties and one of the records
will have an lvalue with the name of your diagram. All the records
with the same objectid are used to store the diagram.

You could DTS the records you need to a text file and check that in.

I think using a tool that could export a diagram as a .tiff or .jpg
(or vsd - Visio) would probably be more meaningful. I'm not sure if
it would be valid to import the diagrams..
 
Back
Top