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: Yesterday @ 11:28 AM
Points: 350, Visits: 624
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: 2 days ago @ 12:52 PM
Points: 219, Visits: 738
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 @ 7:38 AM
Points: 2,671, Visits: 2,083
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