EMail Notifications Possible?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

EMail Notifications Possible?

Postby Stucatz » Mon Nov 28, 2011 7:09 pm

Hi,

I love the source control component and use it daily. Just curious if there exists the functionality to receive emails detailing database objects that have yet to be checked into Team Foundation at the end of the day?

In our company, sometimes our developers forget to check in their changes and this would resolve that.

Thanks,
Stucatz
Stucatz
 
Posts: 3
Joined: Mon Nov 28, 2011 7:03 pm

Postby David Atkinson » Mon Nov 28, 2011 9:37 pm

This isn't built into the product, but I imagine it would be straightforward to write a Powershell script and run a scheduled task (or Agent job) to kick off tf.exe to grab what's in source control, SQL Compare Pro command line to compare this with the development database, to alert you when there are differences, and to attach a difference report.

Are you comfortable with Powershell and the SQL Compare command line? If not, it's something we could help you set up.

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby Stucatz » Mon Nov 28, 2011 11:18 pm

Hi David,

Thanks for the reply, very much appreciated. Unfortunately, we didn't purchase SQL Compare. Could you recommend another option?

Thanks,
Stucatz
Stucatz
 
Posts: 3
Joined: Mon Nov 28, 2011 7:03 pm

Postby David Atkinson » Mon Nov 28, 2011 11:39 pm

That's the only option I can think of. You need some way of comparing the dev DB against what's in source control and SQL Compare Pro seems like the ideal tool for the job.

Do you have a method to identify application code changes that haven't been checked into TFS?

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby Stucatz » Tue Nov 29, 2011 5:33 pm

Not off the top of my head. Maybe I'll look into Visual Studio 2010, see if there is something there I could use.

Thanks for the help Dave!
Stucatz
 
Posts: 3
Joined: Mon Nov 28, 2011 7:03 pm


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 1 guest