edited tags

edited Aug 17, 2017 at 23:21

Question Unprotected by Paul White♦

occurred May 23, 2017 at 16:51

Question Protected by Kin Shah

occurred Sep 24, 2015 at 22:10

Tweeted twitter.com/#!/StackDBAs/status/422388706763628544

occurred Jan 12, 2014 at 15:24

Post Migrated Here from stackoverflow.com (revisions)

occurred Jan 12, 2014 at 14:04

asked Jan 12, 2014 at 14:03

SQL Server 2012: Generate Scripts from command line

I am running SQL Server 2012.

The SQL Server Management Studio has the option to right click on a database then select Tasks and Generate Scripts.

Is there a way to automate that via command line somehow?

I want to create a script that includes the schema and data of the entire data base.

Tools like ScriptDB and sqlpubwiz.exe all seem to target SQL Server 2005. What about SQL Server 2012?

Return to Question