How can we help you today? How can we help you today?

View consolidated change reports/ Automate

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?
jkennedy
0

Comments

2 comments

  • David Atkinson
    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
    0
  • Allen LeVan
    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
    0

Add comment

Please sign in to leave a comment.