Post reply

automating object scripting

  • April 12, 2012 at 10:58 am

    #267313

    Is there any way to automate (scheduled job) the scripting of database objects in 2008? We use scptxfr for previous versions of sql but it doesn't work for 2008. I see the great tool to generate object scripts but no way to schedule a daily occurance of it. thanks

  • April 12, 2012 at 4:07 pm

    #1472983

    SSMS leverages SMO for that, which is installed with the client tools. I do these types of tasks with PowerShell referencing SMO. To my knowledge there is no command-line access to the "Generate And Publish Scripts" functionality in SSMS, and that is a shame.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

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