Red Gate forums :: View topic - EMail Notifications Possible?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

EMail Notifications Possible?

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Stucatz



Joined: 28 Nov 2011
Posts: 3

PostPosted: Mon Nov 28, 2011 7:09 pm    Post subject: EMail Notifications Possible? Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Mon Nov 28, 2011 9:37 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Stucatz



Joined: 28 Nov 2011
Posts: 3

PostPosted: Mon Nov 28, 2011 11:18 pm    Post subject: Reply with quote

Hi David,

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

Thanks,
Stucatz
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Mon Nov 28, 2011 11:39 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Stucatz



Joined: 28 Nov 2011
Posts: 3

PostPosted: Tue Nov 29, 2011 5:33 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group