Post reply

generate the scripts of all tables

  • 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]

  • 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

  • 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]

  • 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.

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply