How to export SQL Server database structure into text format

Question

Possible Duplicate:
How can I automate the "generate scripts" task in SQL Server Management Studio 2008?

I need to export structure of my SQL Server database into a .sql script(s) without management studio.

UPDATED

You could use a third-party tool like [ApexSQL SQL Script](http://www.apexsql.com/sql_tools_script.aspx) to achieve this... `bcp` is really more for the **data** import/export (rather than the database's structure) — marc_s, Aug 13 '11 at 19:48

score 15 · Answer 1 · answered Aug 13 '11 at 19:30

15

In SQL Management Studio:

Right click on Database entry
In menu select Task -> Generate Scripts
Specify what exacly you want to generate (schema only, +functions, +stored procedures,..)

answered Aug 13 '11 at 19:30

sll

3

I want to automize this task, so this approach is not acceptable for me – hazzik Aug 13 '11 at 19:34
So you need to export only schema? – sll Aug 13 '11 at 19:41

score 4 · Answer 2 · answered Aug 13 '11 at 19:32

4

Try out Tasks -> Generate scripts menu in SQL Management Studio

answered Aug 13 '11 at 19:32

xelibrion

2 Answers2