Scripting Database schema

I have a datab开发者_运维技巧ase in my sql management studio how can script the database schema to file so that I can put it in another device?

thanks

Open SQL Management -> Script Database As -> .... I think its the closest to what you mean.

Of course there are 3rd party tools for these kind of works. See RedGate.

Shutdown SQL Server, copy the MDF and LDF Files to a new server and attach them on that instance by right clicking on Databases and choosing Attach. Specify the location of the files.

Alternatively, you could also backup the database from the source and restore it in the destination.

The above two methods copy all data too. If you want only the schema, Right click on the database and choose Generate SQL Scripts and follow the instructions.

SQL Management Studio 2008 can make query to unload Schema and data from database, but older versions if Management studio can't do it. You can use another soft to do it like an EMS SQL Management studio