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

nightly "Monitoring" process?

I currently support a small operation that uses the "Develop on Live" process. Hopefully I can change their mind one day, but until then-

I currently have an automated nightly process that restores the latest database backup, sanitizes sensitive data, sends me the sanitized database, and restores it locally.

Ideally I'd like to link this database to source control, and automatically check in changes so I get a daily overview of changes.
StormRider
0

Comments

5 comments

Sort by
  • David Atkinson
    It isn't that unusual for the production database to be modified directly, rather than having a disciplined change management process.

    Grant Fritchey describes how to solve this problem with SQL Compare's command line and your existing source control tool in a Simple Talk article. Is this the sort of thing you were thinking of?

    http://www.simple-talk.com/sql/database ... databases/

    David Atkinson
    Red Gate
    David Atkinson
    0
  • StormRider
    Thanks David, that's exactly what I was looking for.
    StormRider
    0
  • David Atkinson
    Glad to hear it. Out of interest, which source control system are you using?

    David
    David Atkinson
    0
  • StormRider
    SVN
    StormRider
    0
  • David Atkinson
    We also use SVN here at Red Gate. If you have any issues getting up and running, do let us know and we'll be pleased to assist.

    David
    David Atkinson
    0

Add comment

Please sign in to leave a comment.