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: Thursday, December 11, 2014 11:23 AM
Points: 337, Visits: 598
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:18 PM
Points: 194, Visits: 675
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: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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