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.

SVN post-commit hook to update QA database

Postby spivey24 » Sun Dec 05, 2010 9: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.
Posts: 18
Joined: Tue Oct 17, 2006 2:16 am

Postby peter.peart » Tue Dec 07, 2010 5: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.


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

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests