script to generate schema from existing database

• invaliddba

  Default port

  Points: 1450

  More actions

  January 27, 2012 at 8:30 am

  #391420

  Hello all

  What is the best way to go about coming up with a script that builds the schema out of the existing database?

  In detail ,

  1. I have an existing database with live data.

  2. I want to create a schema copy of the existing db in step 1. Just the structure with all the objects in it ( tables,views,constraints etc ..the list goes on ).

  What are the options I need to explore and the best way to go about it ?

  Thanks in advance

• umasingh

  Ten Centuries

  Points: 1182

  More actions

  January 27, 2012 at 8:35 am

  #1439420

  Here is script to copy the schema

  http://www.sqlservercentral.com/scripts/T-SQL/75703/

• umasingh

  Ten Centuries

  Points: 1182

  More actions

  January 27, 2012 at 8:37 am

  #1439423

  This is by ssms using generate script task.

  http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/