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 |
|
johncogan
Starting Member
20 Posts |
 Posted - 2004-11-25 : 10:32:37
|
| HiIs there anyway to import the table schema (Table names and columns at minimum) into a 3rd party package (possibly visio2000 or any other package) which will allow me to print the tables off.Usually I have to resort to screen shots knitted together in Photoshop.I am looking to use this for reference only and not going to be re-importing the diagram back into Enterprise manager.I've looked at our Visio 2000 installation and see nothing that shows it can do this, help file doesnt say anything as well.TIAJohn |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-11-25 : 11:13:17
|
| Think you may need the Enterprise Edition though am not sure (I have version (6.1.1023))You want the reverse engineering wizardFILE > NEW > DATABASE > Database Model DiagramthenDATABASE > REVERSE ENGINEERYou may need an ODBC data source toosteveTo alcohol ! The cause of - and solution to - all of life's problems |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-11-25 : 11:14:45
|
| If you have the correct version of Visio 2000 (don't know what it's called) you can reverse engineer a database diagram. The option comes up if you make a "database model diagram". I think I have Visio Professional, and it shows up for me. |
|
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-11-27 : 10:03:14
|
| Need Visio Enterprise Architect edition and I think it is only available with visio studio.net |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-27 : 11:59:54
|
Would the Table Views in Enterprise Manager do (if you could screen shot them)?We use a "screen grabber" tool to get screen shots for manuals; it can "scroll & knit" a screen window to get all of it into a single image. Its called Something Capture Pro - I can dig it out if its any help.Kristen |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-11-27 : 18:48:02
|
| Not "Paint Shop Pro" Kristen ?Have You tried, <Alt>+<Print Screen>.Now does anyone here know the command to just "copy" the active window, not the whole screen ?rockmoose |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-28 : 04:28:57
|
"<Alt>+<Print Screen>"Needs a vast screen of course ..."Now does anyone here know the command to just "copy" the active window, not the whole screen"Yeah, Something Capture Pro like wot I said  Kristen |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-11-28 : 09:38:29
|
| There are a few free tools available, though I have'nt used them (we use ErWin & Visio) but you might have a look here:http://www.handyarchive.com/Development/Databases-Networks/10848-SQL-Diagrams.html |
|
|
|
|
|
|
DB Diagram & Visio