Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nato
Starting Member
30 Posts |
 Posted - 2003-07-15 : 10:49:15
|
| I have found this sentence in a posting:"MS Visio is capable of reverse-engineering an existing database and creating an E-R diagram, including any existing FOREIGN KEY references."This is exactly what I need. But I cant seem to figure out how to do it. Can anybody advise please. Please note, that I am new to Visio.Thanks |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-07-15 : 11:08:53
|
| Which version do you have?. I think it requires the pro version. I've used it several times and it works well. |
 |
|
|
Nato
Starting Member
30 Posts |
Posted - 2003-07-15 : 11:12:59
|
| Visio Standard 2002. Anyone know if I can still do it, or do I need to upgrade? |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2003-07-15 : 11:20:14
|
quote:
Visio Standard 2002. Anyone know if I can still do it, or do I need to upgrade?
You need Visio Professional to reverse-engineer and create/update databases. I think you can still do models, tho.~ monkey |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-15 : 12:41:47
|
| Microsoft stikes again!cha-chingPut the money on the barrel....Brett8-) |
|
|
|
Nato
Starting Member
30 Posts |
Posted - 2003-07-16 : 05:59:36
|
| Yeah, Visio Pro has the reverse-engineering functionality. It looks like I am going to be upgrading soon. |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2003-07-16 : 11:54:02
|
quote:
Yeah, Visio Pro has the reverse-engineering functionality. It looks like I am going to be upgrading soon.
Might want to hold out a bit if you can for Visio 2003. Should be pretty cool. 2002 is nice, but still has its quirks. Dunno if they've been worked out in 2003, i have the install disc right in front of me, hope to install it by the end of the week.~ monkey |
|
|
|
|
|
|
DB Diagrams in Visio