SQL Server 2012

Is there a way to export DDL for SQL Server 2012?

A previous question of this nature was given in December 2009, but it does not seem to apply. Previous answer: For SQL Server:

In SQL Server Management Studio, right-click on the database and select Tasks → Generate Scripts.

You will be asked to choose which DDL objects to include in your script. link edited

replied to # 189 Daniel Vassallo 78.6k11129180

I tried this suggestion, but after right-clicking on my database it is not such a "Tasks" option.

Any ideas?

2012 Analysis Services simply has a deployment wizard. I am not deploying, just trying to document. I checked Data Quality Services, Integration Services, Performance Tools, but can't see anything that I learn.

I have been working with SQL Devloper for Oracel for the past few years, but it seems like I remember that ACCESS and SQL Serever controlled the Export Data in the Tools menu. This allowed you to choose what to export, including DDl, with or without data.

I would like to do something like this - include all my tables, but no data.

Any ideas?

Thank.

+5
source share
1 answer

, script DDL SQL Server 2012. SSMS, "" > , , " ". , . . "".

Generate Script - 1

Choose Options Dialog

Scripting Options Dialog

+6

All Articles