copying a database diagram

Hi,

I have a database diagram on my sql server 2005, how can i copy that diagram to my pen drive so that i can build the database using that diagram on another computer...well the bottom line is i want to copy the datbase from one computer to another.

thanks

Vishal

If you want to copy the database from one computer to the other, you'd best make a backup of the database and restore it on the other computer.

http://msdn2.microsoft.com/en-us/library/ms187510.aspx

|||

Checkout these two links:

http://www.codeproject.com/dotnet/ScriptDiagram2005.asp

http://www.dotnetforce.com/Content.aspx?t=a&n=208

Good luck.

|||

how do i go about it??

thanks

Visam

|||

thanks let me check it