generate the scripts of all tables

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  October 25, 2008 at 10:49 am

  #889655

  SSC Journeyman:

  I suspect that you either need to set some options on the command or query the index scripts as a separate set of items. Either way you should ask the creator of the script at Simple-Talk.com.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Manish_

  Ten Centuries

  Points: 1070

  More actions

  October 25, 2008 at 12:21 pm

  #889662

  Yeah Rbarryyoung,

  I did the same, hope I will get some clue, I will try once more tomorrow morning.

  - Manish

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  October 25, 2008 at 3:36 pm

  #889677

  Let us know if you find out what the answer is. 🙂

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  October 8, 2009 at 2:07 pm

  #1063712

  krayknot (10/21/2008)

  ---

  Manish Kaushik (10/20/2008)

  ---

  Hi Guys, Can any one help me out to know

  How to generate the scripts of all tables without the Generate scripts wizard of SQL 2008.

  Thanks

  Manish Kaushik

  create proc sp__GenerateScript

  @dbname varchar(256) = '',

  @Applicationpath varchar(700) ='C:\program files\Microsoft SQL Server\mssql\upgrade\',

  @destinationpath varchar(700) ='D:\MSSQLScripts\',

  @switches varchar(200) = ' /X /Y /A /q /r /G /I '

  as

  --Created by:MAK

  --Date: Aug 28, 2004

  --Objective: Generate SQl Scripts for all or given database

  Did anyone try this ? I tried it on a small database and it ran for 25 minutes before I decided to cancel it .... not sure what's going on. I copied the exe from a 2000 machine to my 2005 machine, fwiw.