Project Description
The DBScirpterCmd is a command line tool to script database objects to separate SQL files. An interesting use is with an automation tool, such as NAnt or FinalBuilder, to script database objects and check in to a source control system automatically.

At present this program supports Microsoft SQL Server 2014, 2012, 2008, 2005 and 2000, and database objects: table, stored procedure, view, user defined function, aggregate, type, data type and table type.

SQL Server 2008 Management Objects and .Net Framework 4.5.1 is required to run this program.

 

EXAMPLE:
DBScripterCmd.exe localhost sa test AdventureWorks2008R2 "d:\output" 

 

USAGE:
DBScripterCmd.exe <server> <uername> <password> <database> <output folder> [s][t][v][u]

where
  s        Stored Procedure
  t        Table
  v        view
  u        User defined objects (function, aggregate, data type, table type, type)
  Empty    All

 

 DBScripterCmd.jpg

 

 Sequence Diagram


Last edited Mar 30, 2015 at 8:03 PM by jim1032w, version 33