creating diagrams from SQL Scripts

Hi,

i'm in the modeling area of the portuguese post, and i've a doubt.

i've scripts of some DB (that i've exported from SQL Server) that i want to register im my default SQL (local). But when i run the script of creating the DB on my machine, it doesn't create the diagrams.

Is there any way that i've got this ?

thanks,

Jo?o P.

The diagrams are data stored in system tables so they wouldn't be included in the script of the database.

If you have access to the original database, there are some ways to move/import the diagrams but how you do this depends on what version of SQL Server. If you want to do that, please post back the version of SQL Server (is it SQL Server 7.0, 2000, 2005, etc)

-

|||

Thanks,

my version of SQL is 2000.

cheers,

Jo?o Pedro

|||

This article explains how to move diagrams on SQL 2000:

How To Move a Database Diagram

http://support.microsoft.com/kb/320125

-Sue

|||

thanks for the help,

cheers,

jo?o Pedro