Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server's Generate Scripts Expand / Collapse
Author
Message
Posted Monday, February 17, 2014 11:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, June 28, 2015 3:20 PM
Points: 358, Visits: 637
This (SSIS?) package works great, but is there a way I can script out its use? Every month when we refresh our dev boxes I need to capture the database .. in case a change was not moved into production and not scripted out to file. We have a lot of databases, so it would be great not to have to do this by hand every month.
Post #1542230
Posted Monday, February 17, 2014 1:15 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:52 AM
Points: 219, Visits: 756
You can use SQL Server Management Objects (SMO) to programmatically script out database objects. An intro to SMO scripting you can find here: http://technet.microsoft.com/en-us/library/ms162153.aspx



___________________________
Do Not Optimize for Exceptions!
Post #1542265
Posted Monday, February 17, 2014 10:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:49 AM
Points: 2,793, Visits: 2,162
Also when designing SSIS package you can define action if step fails take this action if step successful take this action to control the steps.

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1542365
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse