Generating Script for DATABASE SCHEMA & DATA

• Hakuna Matata

  SSCertifiable

  Points: 5577

  More actions

  February 16, 2011 at 4:48 am

  #99550

  I have a DATABASE running on SQL SERVER 2008 R2 Enterprise Edition. Now I want to generate a Script which should provide me the DATABASE SCHEMA including the STORED PROCEDURES, FUNCTIONS, INDEXES (In short everything except data). With the Schema i also need some of the tables with DEFAULT DATA to be populated.

  Please advise.

• Marco V

  SSCrazy

  Points: 2939

  More actions

  February 16, 2011 at 5:28 am

  #1287574

  right click database,

  Tasks

  Generate Scripts...

  Follow the wizard and include all the items what you want to be script of a certain database...

  EDIT: ouch saw it to late it was in the SQL 7 /2000 forum. If this is correct ignore my answer

  EDIT2: just checked it on a SQL 2000 its also there the script wizard 😀