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

Copy stored procedures from SQL to SQL DE?

Is there an easy way to copy all stored procedures from an SQL server to en SQL Desktop Engine or do I have build all stored procedures by hand?You can use the SQL Server import/export wizard, or you can generate a script of them using SQL Server Management Studio.|||

Thanx,

In the mean time I copied them manually (copy-paste).

So I think a seperate script would be usefull when you have 100+ stored procedures. Or have the script available.