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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 database schema needed

Author  Topic 

shekhar_dba
Starting Member

39 Posts

Posted - 2006-07-26 : 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

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
Go to Top of Page

shekhar_dba
Starting Member

39 Posts

Posted - 2006-07-26 : 18:04:20
yes i need diagram of database
Go to Top of Page

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
Go to Top of Page

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 ???
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -