Author |
Topic |
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-07-26 : 17:55:13
|
Hi gurusI would like to print databse schema in sql server 2000 ..... Is there any way to print database schema from enterprise manager ???Thanks for help |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-26 : 17:57:18
|
Yes. What type of format do you want? Do you just want to see the CREATE, ALTER, etc... statements or do you want a nice diagram of it?Tara Kizer |
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-07-26 : 18:04:20
|
yes i need diagram of database |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-07-26 : 18:06:16
|
Create a database diagram with Enterprise Manager, and then print it.CODO ERGO SUM |
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-07-26 : 18:08:05
|
okay thats fine ..... but what abt if i need create, alter ect statements ??? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-26 : 18:08:51
|
if you have visio (pro or whatever the top one is) then you can get some nice diagrams from it also. Not free, but many shops already have/own visio so I thought I'd mention it.-ec |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-26 : 18:09:56
|
quote: Originally posted by shekhar_dba okay thats fine ..... but what abt if i need create, alter ect statements ???
Right click on the database, go to All tasks, then generate SQL script. Select the options that you want scripted.Tara Kizer |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-26 : 18:11:19
|
quote: Originally posted by shekhar_dba okay thats fine ..... but what abt if i need create, alter ect statements ???
sounds like you may need a data modeling tool then. As mentioned before, visio can kind do a lot of this for you. You can also go out and spend a lot of money on tools like Erwin or Powerdesigner.-ec |
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-07-26 : 18:12:53
|
okay ........... information solves my purpose......thanks alot to all of u thanks |
|
|
|