nightly "Monitoring" process?

StormRider · January 21, 2012 12:56PM

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.

David Atkinson · January 21, 2012 2:25PM

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

StormRider · January 22, 2012 10:40PM

Thanks David, that's exactly what I was looking for.

David Atkinson · January 23, 2012 4:03AM

Glad to hear it. Out of interest, which source control system are you using?

David

StormRider · January 23, 2012 11:41AM

SVN

David Atkinson · January 23, 2012 12:06PM

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

nightly "Monitoring" process?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

nightly &quot;Monitoring&quot; process?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

nightly "Monitoring" process?