| Author |
 Topic  |
|
|
shekhar_dba
Starting Member
39 Posts |
 Posted - 07/26/2006 : 17:55:13
|
Hi gurus
I 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
USA
35007 Posts |
Posted - 07/26/2006 : 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 - 07/26/2006 : 18:04:20
|
yes i need diagram of database
|
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 07/26/2006 : 18:06:16
|
Create a database diagram with Enterprise Manager, and then print it.
CODO ERGO SUM |
|
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 07/26/2006 : 18:08:05
|
okay thats fine ..... but what abt if i need create, alter ect statements ???
|
|
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 07/26/2006 : 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
USA
35007 Posts |
Posted - 07/26/2006 : 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
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 07/26/2006 : 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 |
Edited by - eyechart on 07/26/2006 18:11:41 |
|
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 07/26/2006 : 18:12:53
|
okay ........... information solves my purpose......
thanks alot to all of u
thanks |
|
|
| |
Topic |
|
database schema needed
