<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Wagner Crivelini
»
Database Modeling and Diagrams with SQL...
28 posts, Page 1 of 3
1
2
3
»
»»
Database Modeling and Diagrams with SQL Server 2008
Rate Topic
Display Mode
Topic Options
Author
Message
wagner crivelini
wagner crivelini
Posted Monday, May 18, 2009 10:35 PM
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, January 30, 2013 10:57 AM
Points: 28,
Visits: 173
Comments posted to this topic are about the item
Database Modeling and Diagrams with SQL Server 2008
Post #719533
Henk Schreij
Henk Schreij
Posted Tuesday, May 19, 2009 12:56 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, May 13, 2013 3:02 AM
Points: 235,
Visits: 560
In SqlServer2000 I used the Database Diagram for documentation.
I divided the Database (120 tables) in four diagrams (each the size of a single page A4) on the 4 subjects of the db (customers, employees, bookings, internet). I copy-pasted (printscreen) in in a Word document and had a low cost superb solution.
But then came 2005 and the captions (table name)came in a new big bold font. And it needed an empty line at the bottom (or you get a scrollbar which makes the table ugly and more width). And it didn't fit on a page any more. So 2005 blew up my documentation
Post #719558
Mark Ashworth
Mark Ashworth
Posted Tuesday, May 19, 2009 1:00 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 21, 2009 12:31 AM
Points: 4,
Visits: 7
Hi,
Figure 6 is incorrect, you do not have to create the script and then return to the database model. You need to turn off the validation that SQL Management Studio has built in for changes that require a table to be recreated.
The option is available at Tools | Options | Designers | Prevent saving changes that require table re-create.
Regards,
Mark P Ashworth
http://www.connext.co.za
Post #719559
Parag Mehta
Parag Mehta
Posted Tuesday, May 19, 2009 2:26 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 13, 2009 3:35 AM
Points: 1,
Visits: 10
I didn't understand the purpose of this article. These things existed in the last century as well
Post #719595
si_downes
si_downes
Posted Tuesday, May 19, 2009 3:05 AM
SSC-Addicted
Group: General Forum Members
Last Login: Monday, November 05, 2012 7:45 AM
Points: 426,
Visits: 215
nice naming convention on your tables
Post #719610
Victor Kirkpatrick
Victor Kirkpatrick
Posted Tuesday, May 19, 2009 5:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 6:25 AM
Points: 1,366,
Visits: 289
As far as export, you can also use one of last century's commands to get a file copy of your diagram:
bcp MY_DB..sysdiagrams out MY_DIAGRAM.bcp -c -T -S SERVERNAME
Then you can restore the db all you want and then bcp the diagram back in when needed. Yes, I know, there are other more modern methods. Just throwing this out there.
Post #719693
magarity kerns
magarity kerns
Posted Tuesday, May 19, 2009 7:05 AM
Old Hand
Group: General Forum Members
Last Login: Monday, May 13, 2013 10:22 PM
Points: 358,
Visits: 393
I gave this article a good score - I don't know why it is getting bashed in the ratings (only an average of 2 when I voted). The English is well written and it covers most of the basics of the diagram tool. I already knew all of the material (I always use the diagram tool) but I'm going to assign my intro database students to read this next semester along with the other articles they get assigned.
Post #719762
Chris Harshman
Chris Harshman
Posted Tuesday, May 19, 2009 7:12 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 12:03 PM
Points: 1,563,
Visits: 1,718
I like the database diagraming tools within SQL Server, however I learned not to use them because they are tied to intimately with the database. In 2005, I built up elaborate diagrams of each schema of the system I work on, but then when it came time to do an entire database refresh into our dev environment from the test environment, I couldn't find a way to export the diagrams out of the database in a way that could be imported back in later after the refresh (refresh was a backup and restore of test database). Does anyone know if they've solved this issue or found a way that I've missed? Untill then, I'll stick with outside tools to do my documentation and diagraming.
Post #719773
Stephen.Richardson
Stephen.Richardson
Posted Tuesday, May 19, 2009 7:13 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, December 21, 2012 6:44 AM
Points: 26,
Visits: 133
I stopped using the DD because when visualizing the DB and you link or make a change to the diagram it actually makes the change in the DB tables. What I have been looking for is a tool like this to use for documentation, and the actual foreign keys and linkages are done programmatically through views/SP/Scripts. Problem with Visio is our version will not read 2005 let alone 2008.
Post #719775
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, May 19, 2009 7:45 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 12:07 PM
Points: 31,431,
Visits: 13,741
Parag Mehta (5/19/2009)
I didn't understand the purpose of this article. These things existed in the last century as well
Not everyone has been using SQL Server for more than one version. We get new people all the time and publish articles to help all levels of users.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #719816
« Prev Topic
|
Next Topic »
28 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
