Database Diagram

Question

Post reply

Database Diagram

Feivel

SSCertifiable

Points: 7524
More actions
August 11, 2014 at 3:03 am

#291881

[font="Comic Sans MS"]Hi, I've been tasked to create a database diagram, save it and send that db diagram to the user. Now, I am confused as I don't know where sql server stores the db diagram...what is the path where it stores the diagram. How do I export it in case if I need to provide it to the user. How, am I supposed to grant user permission so he himself can create a database diagram. Pls. let me know as this is quite urgent...any help would be appreciated.
Regards,
Faisal
[/font]

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

desperadomar Mr or Mrs. 500 Points: 539 More actions · Answer 1

I think the diagram is an object in the database . Need to backup and restore it to get access it

Feivel SSCertifiable Points: 7524 More actions · Answer 2

[font="Comic Sans MS"]Thanks! but that's not the answer I am expecting...there has to be some other way of doing it. May be import\export or something I am not sure off.

Regards,

Faisal

[/font]

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

First hit I got after google'ing

http://msdn.microsoft.com/en-us/library/aa337550.aspx

Feivel SSCertifiable Points: 7524 More actions · Answer 4

[font="Comic Sans MS"]Thanks! bub. However, I am looking for an alternative to get that done...may be extract that out from db to a file (could be an img file or something). How about taking it out and putting that in visio. Do you guys have any info on how do we extract it into visio.

Regards,

Faisal

[/font]

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

Could try something like using BCP to export the varbinary column out to a file, that might work, or a CLR procedure which reads and writes the varbinary out to a file.

Feivel SSCertifiable Points: 7524 More actions · Answer 6

anthony.green (8/11/2014)
Could try something like using BCP to export the varbinary column out to a file, that might work, or a CLR procedure which reads and writes the varbinary out to a file.

[font="Comic Sans MS"]Do you have anything in practice. I would appreciate if you could give me some example scripts on how to do this...in case if you have done something like that before. Appreciate your help 🙂

Regards,

Faisal

[/font]

Ant-Green SSC Guru Points: 113507 More actions · Answer 7

Google has a lot of stuff on this, not done it personally myself, but a quick search did return how to do it.

"export varbinary to file"

Feivel SSCertifiable Points: 7524 More actions · Answer 8

anthony.green (8/11/2014)
Google has a lot of stuff on this, not done it personally myself, but a quick search did return how to do it.
"export varbinary to file"

[font="Comic Sans MS"]Thanks! buddy. I know Google has a lot of stuff, if I would have to Google and get the answer...why would I even bother posting a question in this forum...think of it 😉

Regards,

Faisal

[/font]

Ant-Green SSC Guru Points: 113507 More actions · Answer 9

That is true, but as I don't want to re-iterate what is already out on the web a simple search on Google for the phrase "export varbinary to file" will produce a number of results which will give you what you should hopefully need to complete the task.