Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to export SQL Server database structure into text format [duplicate]

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

like image 402
hazzik Avatar asked Dec 04 '22 07:12

hazzik


1 Answers

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,..)
like image 112
sll Avatar answered Jan 06 '23 07:01

sll