Database Diagram in SQL Server 6.5

Hi
I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In SQL SERVER 2000, I know how to create a database diagram using Enterprise Manager.
We have got another system which is based on SQL SERVER 6.5. I want get a database diagram of this database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5
Thanks
ShailajaI think that this may be useful:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlugrd.asp|||It's been a while since I worked with SQL Server 6.5, but I don't think the
diagramming feature is available in SQL Server 6.5
You could generate a script for all the 6.5 tables, including the
relationships. Then create a database in SQL Server 2000, and run those
scripts to recreate the tables. Once the tables are created, you could use
SQL Server 2000 Enterprise Manager to generate disgram from this database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
Hi,
I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In
SQL SERVER 2000, I know how to create a database diagram using Enterprise
Manager.
We have got another system which is based on SQL SERVER 6.5. I want get a
database diagram of this database. Can you please suggest how to get the
Database Diagram in SQL SERVER 6.5.
Thanks,
Shailaja|||Hi,
In SQL 6.5 you can not create diagrams. infact there was no options for
diagrams.
To add on Vyas post,
1. Generate the table creation script and save the file as table.sql
2. If you have ERwin or any other database modeling tool, you can reverse
engineer the table.sql to get a ER diagram.
Which is identical to SQL server diagrams
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eDBXdHY6DHA.2540@.TK2MSFTNGP11.phx.gbl...
> It's been a while since I worked with SQL Server 6.5, but I don't think
the
> diagramming feature is available in SQL Server 6.5
> You could generate a script for all the 6.5 tables, including the
> relationships. Then create a database in SQL Server 2000, and run those
> scripts to recreate the tables. Once the tables are created, you could use
> SQL Server 2000 Enterprise Manager to generate disgram from this database.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
> news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
> Hi,
> I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In
> SQL SERVER 2000, I know how to create a database diagram using Enterprise
> Manager.
> We have got another system which is based on SQL SERVER 6.5. I want get a
> database diagram of this database. Can you please suggest how to get the
> Database Diagram in SQL SERVER 6.5.
> Thanks,
> Shailaja
>|||On Mon, 2 Feb 2004 03:31:06 -0800, Shailaja Somisetty wrote:
>I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In SQL SERVER 2000, I know how to create a database diagram using Enterprise Manager.
>We have got another system which is based on SQL SERVER 6.5. I want get a database diagram of this database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5.
Take a look at Visio. Several versions will allow you to reverse
engineer a diagram from SQL Server 6.5, and the Enterprise versions of
Visio 2000 and 2002 also allow you to generate SQL DDL script from the
diagrams.
If all you want is to diagram and document an existing database (i.e.
you never want to generate scripts from your diagram / design), then you
don't need to spend the extra bucks on Visio Enterprise - just get Visio
Professional.
NB: Visio Standard doesn't do database diagrams!
http://www.microsoft.com/office/visio/prodinfo/default.mspx
Also, I think that Visio Enterprise is now part of VS.Net Enterprise -
can't remember, but you can check that out on the website.
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander|||FWIW, as far as I remember, Visual Studio has diagram feature that work against 6.5.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
> Hi,
> I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In SQL SERVER 2000, I know
how to create a database diagram using Enterprise Manager.
> We have got another system which is based on SQL SERVER 6.5. I want get a database diagram of this
database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5.
> Thanks,
> Shailaja|||Thanks for your valuable inputs
Shailaja