View consolidated change reports/ Automate

jkennedyjkennedy Posts: 18
edited May 29, 2015 1:46PM in SQL Source Control Previous Versions
I'm hoping to leverage this product on an upcoming SOD initiative. Is there an ability to automate compares? An example. We have 20 databases. Can I schedule automated change commits to occur every Friday? Can I view a consolidated report showing all changes for a particular period?
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,460 Rose Gold 2
    You could script this with sqlcompare.exe (SQL Compare's command line) and your version control tool command line.

    However, automating commits might not be considered good practice, as you would lose the audit trail of which developer made the change and why (via the check in comment).
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • Allen LeVanAllen LeVan Posts: 75
    Hello,

    With SQL Compare command line you could script out compares you want to perform and then use some way to kick them off on a schedule. There are no built in scheduling tools to SQL Compare or SQL Source Control.
    Allen LeVan
    Red Gate Software
    US Product Support
    · Share on Twitter
Sign In or Register to comment.