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 2005 Forums
 SQL Server Administration (2005)
 How to generate database diagram?

Author  Topic 

markshen2006
Starting Member

15 Posts

Posted - 2008-04-07 : 14:46:04
Hi,

I want to create a empty database with a existed database.

I create all the tables with script that is generated with takes -> generate script command.

I do not know how I can cope the existed database diagram to the empty database.Please give me a idea.

Thanks for your help.

Mark

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-07 : 15:01:55
Go to Database Diagram -Add tables you scripted.
Go to Top of Page

markshen2006
Starting Member

15 Posts

Posted - 2008-04-07 : 15:04:07
do you mean I have to do the Database Diagram again in the empty database? I want to copy the current one.

Thanks

Mark
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-07 : 23:30:41
Don't think you can copy that. Anyway, why need another diagram if target db is same as source db?
Go to Top of Page
   

- Advertisement -