June 13, 2013 at 4:29 pm
Had a question about database diagrams.
We want to set up a diagram to mainly get the benefit of visualizing our data, and establishing the relationships. The tables we have are old and do not always have a simple key.
The diagram seems like a good fit, but does anyone know if we can set it up so that the relationships set up in the diagram do not enforce any rules or effect the tables the reference in any way? We don't want to effect the tables, only get a layout of the data we have.
Is there a better tool to use outside of Management Studio 2008 R2 to set up these relationships for visualization only?
Any help would be appreciated!
June 13, 2013 at 4:53 pm
I personally prefer Visio because I can get as detailed or as generic as I like. Also it's what I'm the most comfortable with.
ERWin is another heavily used application for things like this, and gives you the layer of disconnect where you can either model existing or model there and then enforce it on existing. It's a pretty neat tool once you get used to it.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 13, 2013 at 5:10 pm
Ok I really appreciate the suggestions. Do you know if by using the database diagram you can set it up so that you can make sure you don't change any actual data or enforce rules onto those tables you diagram?
June 13, 2013 at 5:25 pm
I believe you can (as of '05 you could). You have to do it manually though. It can only auto-generate from existing Relational Integrity rules. It's been a while since I fought with it though, mostly because printing the thing is such a pain in the arse.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 13, 2013 at 5:46 pm
Yea our tables don't have any relational information set up, they are coming from and AS400 into SQL server and no one really knows how they tie so we are trying to setup a road map per say. If you have any ideas or suggestions on where to look to see how to set up the diagrams without effecting the actual data or tables I would sincerely appreciate it. Otherwise I may look at the ERwin to see what it can do and cost etc...
June 14, 2013 at 6:44 am
The database diagram tool in SQL Server can create relationships, which does modify the tables. If you want to create the diagrams for visualization only, I'd also suggest using something else like Visio suggested above.
June 14, 2013 at 7:35 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply