CODEWITHSUNDEEP
sqldatabase
Bobj-C
Bobj-C

Reputation: 5426

Scripting Database schema

I have a database in my sql management studio how can script the database schema to file so that I can put it in another device?

thanks

Upvotes: 0

Views: 623

Answers (3)

Arun
Arun

Reputation: 3077

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.

Upvotes: 1

xplat
xplat

Reputation: 8624

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.

Upvotes: 3

kutsoff
kutsoff

Reputation: 345

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

Upvotes: 0

Related Questions