SVN post-commit hook to update QA database

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

SVN post-commit hook to update QA database

Postby spivey24 » Sun Dec 05, 2010 10:37 pm

Is there a way to do an SVN post-commit hook so we can update the QA databases when a developer checks in the code? According to a couple of articles I found on this site, I would need to set up scripts using SQL Compare Pro. I was told during the evaluation, that syncing the QA databases was possible with NO additional server licenses.
spivey24
 
Posts: 18
Joined: Tue Oct 17, 2006 3:16 am

Postby peter.peart » Tue Dec 07, 2010 6:10 pm

Hi there,

Thanks for your post. It is correct that you would need to use SQL Compare PRO to do this.

You could, I guess, do this manually if you all linked up the QA database to SVN and performed a manual update against the QA from SVN whenever a change was checked in, but I would personally suggest using SQL Compare PRO as that will probably be cleaner.

HTH!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests