Export schema from command line

• Dan Franklin

  SSC Veteran

  Points: 204

  More actions

  October 22, 2004 at 8:40 am

  #161757

  Hello,

  I need to set up a script that will dump the database schema to a text file for use in a source control system. I want to run it automatically so I can easily do comparisons between dev and live servers.

  Is there a way to accomplish what Enterprise Manager does via Generate SQL Script of all objects, with permissions, etc. but using the command line? Thanks for any advice.

  Dan Franklin

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736455

  More actions

  October 22, 2004 at 11:02 am

  #527697

  You can use VBScript and DMO to accomplish this:

  http://www.nigelrivett.net/DMOScriptAllDatabases.html