SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 database schema needed
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shekhar_dba
Starting Member

39 Posts

Posted - 07/26/2006 :  17:55:13  Show Profile  Reply with Quote
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
36601 Posts

Posted - 07/26/2006 :  17:57:18  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 07/26/2006 :  18:04:20  Show Profile  Reply with Quote
yes i need diagram of database
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/26/2006 :  18:06:16  Show Profile  Reply with Quote
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 - 07/26/2006 :  18:08:05  Show Profile  Reply with Quote
okay thats fine ..... but what abt if i need create, alter ect statements ???
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 07/26/2006 :  18:08:51  Show Profile  Reply with Quote
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

USA
36601 Posts

Posted - 07/26/2006 :  18:09:56  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 07/26/2006 :  18:11:19  Show Profile  Reply with Quote
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
Go to Top of Page

shekhar_dba
Starting Member

39 Posts

Posted - 07/26/2006 :  18:12:53  Show Profile  Reply with Quote
okay ........... information solves my purpose......

thanks alot to all of u

thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000