Making SSDT just generate a SQL script (and not deploy a database)

sql visual-studio-2010 sql-server-data-tools
noonand picture noonand · Apr 5, 2012 · Viewed 10.1k times · Source

Having recently upgraded to SSDT 2012 I seem to be missing the option to just generate a T-SQL script instead of deploying the database to a server somewhere.

To be more accurate the predecessor to SSDT used to set the Deploy action to 'Generate script', but I cannot locate that option anywhere in the new version.

Is it possible?

Answer

Lynn Langit picture Lynn Langit · May 25, 2012

To generate a script from an offline data project in SSDT rather than deploy to a target database, configure the project settings as shown below

SSDT deployment configuration dialogue boxes

Related questions

Uninstalling SQL Server Management Studio 2014 in Windows 8

I have a student who installed SQL Server 2014 with tools, but the Management Studio part did not install. There is no SSMMS.EXE on the machine. So I tried to reinstall it, and the Management Studio tools come up checked …

Read More
SQL Server unique constraint problem

How to create a unique constraint on a varchar(max) field in visual studio, visually. the problem is when i try it: manage indexes and keys > add > columns I can only chose the bigint columns, but not any …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More