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.
source
share