Generate SQL server scripts from command line?

windows sql-server-2008 scripting wizard ssms
Luke Sampson picture Luke Sampson · Aug 21, 2009 · Viewed 15.9k times · Source

In Microsoft SQL Server Management Studio 2008 there is a "Generate scripts..." option under the Tasks menu. I'm just wondering if this tool is available from the command line somehow?

Screenshot of Generate SQL Server Scripts Wizard

It looks similar to the sqlpubwiz.exe command line tool that was available for SQL Server 2005, but I can't find this executable anywhere in the SQL 2008 installation.

Answer

Remus Rusanu picture Remus Rusanu · Aug 21, 2009

The script generating options of Management Studio are just a wrapper around the SMO scripting capabilities. Simple scripts are obtained by using the Script() method on various SMO types. More complex scripts are created by the specialized Scripter class.

Command line tools can be easily created by using the SMO libraries.

Related questions

Access denied for enabled xp_cmdshell for the admin user

I'm using xp_cmdshell within a database trigger to launch a exe file. xp_cmdshell is enabled(it can execute simple cmd command like 'echo'). But when I try to launch the exe through xp_cmdshell, the access is denied. …

Read More
MSSQL2008 - Pyodbc - Previous SQL was not a query

I can't figure out what's wrong with the following code, The syntax IS ok (checked with SQL Management Studio), i have access as i should so that works too.. but for some reason as soon as i try to create …

Read More
PHP 5.5.0 w/ Microsoft SQL Server 2008 R2 - No sqlsrv_connect()?

I have the following environment: Windows Server 2008 R2 IIS 7.5 Microsoft SQL Server 2008 R2 I want to use the new PHP 5.5.0 version, which works just fine per sé, but I can't connect to the MSSQL server due to the lack of …

Read More